Enter Parameter Value

[david.paton]

Hi,

I have a problem when I try to open a form called frmCrisisSupportWorkers from a database I am making. When I do, a message box keeps appearing that says "Enter Parameter Value: tblTCLocation.tclcation" but I don't know where this is coming from or why it is appearing.

I have been trying to get the search function of the database working and this function appears to work once you hit ok but I don't know how you get rid of this message box. Any help would be appreciated.

I have attached my database.

Thanks in advance,
Dave
Dave

 

[Galaxiom]

Most often these things are left behind in the OrderBy property of the form after a field name has been changed in the RecordSource. They can also be in the ConditionalFormatting.

Looks like you probably changed a name of a field.

 

[david.paton]

I did change the name of a field but I can't find the OrderBy property to check if the old field names are in there. Where should I look?

 

[Galaxiom]

Open the form in design view.

Turn on the Properties window.

Be sure you have the Form properties rather than one of the controls. Order By is on the Data Tab

 

[david.paton]

There is nothing in orderby

 

[Galaxiom]

What happens if you directly run the query that is the RecordSource property of the form?

 

[david.paton]

I have a text box where you type criteria in and it searches through the records looking for that criteria. If I type in something and click the button when the form is open, it opens the query with the results that match the criteria.

 

[Galaxiom]

What is the RecordSource property of the form?

Usually it is a query and it seems that query has a reference to the old field name.

 

[david.paton]

Not sure what happened but the orderby property appeared. It is:
[tblCrisisSupportWorkers].[cCSWID], [tblCrisisSupportWorkers].[cLastName]

The record source is:
tblCrisisSupportWorkers

 

[Galaxiom]

Try installing V-tools and use the Total Deep Search to find the term it is asking for.

 

[david.paton]

Thanks for that. Total deep search showed me where to find the error.