Enter Parameter Value???

[louisa]

I have just opened my database which is set to open my contacts page which now has pop up Enter Parameter Value "Call ID", i have no idea where this has come from or how to get rid of it can anybody advise?

 

[DJkarl]

You will receive Enter Parameter Value when it cannot find a field in the bound data source of your form. Open the query/table your form is bound to and look for the Call ID field, if the name has changed or the field no longer exists you will have to update your form control that is bound to that field.

 

[vbaInet]

Do you have a field called Call ID in any of your tables?

 

[louisa]

In my contact history table there is a call ID field???

 

[vbaInet]

Follow what DJkarl has suggested. There could be a problem with the syntax. Maybe copy and paste the sql string here.

By the way, are you using the contact history table in the Contacts page you're trying to open?

 

[louisa]

My db opens my contact page on start up which is when i receive the Enter Parameter Value. I have looked at my table bound to the contact page and call i.d isnt there and am not 100% but dont think it ever was????

 

[vbaInet]

Can you post a copy of your db?

Obviously, removing sensitive info.

 

[louisa]

Problem resolved now, thank you for your help.

 

[vbaInet]

Excellent! What did you do?

 

[louisa]

on my call history i had removed part which then wasnt visible so i simply put it back and the problem went away??? not really sure how it had even been removed to be honest.

 

[vbaInet]

Glad it's sorted.

 

[ljmellor]

Hello - I have a similar situation. Have a contact detail form, linked to contacts extended query. When I open the contact detail form I get "enter parameter value - form!id. I've checked the contacts extended query and can't find a "form!id"?? Any suggestions??

 

[pr2-eugin]

Is it possible if you could show us the Query?

 

[ljmellor]

sure, but how do I just attach the query? Sorry to be so lame!

 

[pr2-eugin]

Go to the 'Query Design' window and at the bottom right corner you will have SQL,

click the SQL and it will show the Query.. Copy it and paste it here..

 

[ljmellor]

perfect. .. here it is:

SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Contact Name], Contacts.*
FROM Contacts
ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));

 

[pr2-eugin]

In your Contact details form do you have an Unbound ComboBox? If so check its RowSource.. It might help you identify some problems..

 

[ljmellor]

i have an unbound "go to" box that has the row source as:

SELECT [ID], [Contact Name], [Company], [E-mail Address] FROM [Contacts Extended] WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Contact Name];

 

[pr2-eugin]

So is that not the parameter that is keeps popping up with???

i have an unbound "go to" box that has the row source as:

SELECT [ID], [Contact Name], [Company], [E-mail Address] FROM [Contacts Extended] WHERE [ID]<>Nz(Form![ID],0) ORDER BY [Contact Name];

What is that you are trying to do? If it needs to refer to the form control.. then it should be..

Forms![COLOR=Blue]ContactDetailsFormName[/COLOR]![ID]

Where ContactDetailsFormName would be the name of the Form.. If there is no significant need for the WHERE statement just delete the WHERE bit and have it as..

SELECT [ID], [Contact Name], [Company], [E-mail Address] FROM [Contacts Extended] ORDER BY [Contact Name];

 

[ljmellor]

I tried both of your suggestions, and it still is not working, clearly I am missing something. I am going to just delete the field. Thanks for your help, I appreciate your time!