Enter Parameter Value

**letterbox** · Sep 12th, 2008, 10:01 AM

Hey All!

I took a template from Office online and took bits out and added bits in.

Now every Time i open a form it asks for

Enter Parameter Value
ContactID

I have looked in every form, query etc etc and cannot find this anywhere, its getting very irritating.

Basically all i want is a minimal CRM type database!

**Joe4** · Sep 12th, 2008, 10:12 AM

Look at the Control Source of that form (it should be a table or query).
That message usually means one of two things:
1. The Control Source is a Paramater Query (or a Query that uses a Parameter Query);
2. The "ContactID" field does not exist in the Control Source.

**letterbox** · Sep 12th, 2008, 11:06 AM

ContactID does not exist, thats my point, i dont want it to exist i deleted all reference to it, and it still gives me this error!

**Joe4** · Sep 12th, 2008, 11:12 AM

It exists somewhere on your report. Check the "Sorting and Grouping" icon. That is often the culprit. If it does not show up there, check all text boxes (especially ones that are calculated).

**RoryA** · Sep 12th, 2008, 11:43 AM

If the form is based on a query, open the query in design view, choose Query-Parameters from the menu and make sure it's not listed in there (even if it's not used, you'll get prompted)

**letterbox** · Sep 15th, 2008, 04:44 AM

There are no Queries, they have all been deleted, it is still requesting the information.

**RoryA** · Sep 15th, 2008, 05:24 AM

What is the Recordsource for the form and how are you opening it - manually by double-clicking it, or using code?

**letterbox** · Sep 15th, 2008, 07:43 AM

i AM RIGHT CLICK >> OPEN
the source is a table of data.

I have searched through every form/table for ContactID and cannot find it anywhere.

Thanks for any help!

**RoryA** · Sep 15th, 2008, 08:18 AM

What controls do you have on the form and have you checked the control source for each one (especially any SQL statements that are the row source for any comboboxes or listboxes you may have)
Incidentally, which template was it and which form are you looking at?

**letterbox** · Sep 15th, 2008, 08:25 AM

http://office.microsoft.com/en-us/te...CT101426031033

THATS THE TEMPLATE.

I am wokring on the Contacts Table, I have delated a lot of tables and stuff and added in new ones and new field, that are more relevant to my work.

I am sorry I cannot post it here, i have already imported all the clients.