Enter Parameter value problem

[Denis]

I have a database which has been in use for quite some time. Recently I
changed a field name in TableA from county to country. This table is
related to TableB and TableC and also part of a query.

Now when I open TableA or TableB or the query, a dialog box opens asking
"Enter Parameter Value" for TableA.county with the blank datasheet in the
background (only the first field of the first record is filled). If I click
OK or cancel or Esc the dialog box disappears and the datasheet fills up
with all the records. I have looked at the query and the tables in design
view but can see nothing which might be triggering the parameter value
request.

Is there a way to find what is causing this?

Denis

 

[Guest]

If a field name gets changed, a query field (in your case) would get changed
to

expr1: [formname].[country]

Could there be something in the VBA code?

 

[Denis]

I managed to find the source of this. Was in tableB & tableC Lookup Row
Source of a field in tableA which still referred to county instead of
country.

If a field name gets changed, a query field (in your case) would get
changed
to

expr1: [formname].[country]

Could there be something in the VBA code?

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I have a database which has been in use for quite some time. Recently I
changed a field name in TableA from county to country. This table is
related to TableB and TableC and also part of a query.

Now when I open TableA or TableB or the query, a dialog box opens asking
"Enter Parameter Value" for TableA.county with the blank datasheet in the
background (only the first field of the first record is filled). If I
click
OK or cancel or Esc the dialog box disappears and the datasheet fills up
with all the records. I have looked at the query and the tables in
design
view but can see nothing which might be triggering the parameter value
request.

Is there a way to find what is causing this?

Denis