How to remove ''Enter parameter value''

[JulieL]

I deleted like 10 field names in my Employees table. When I want to go in my
Employees form, ''Enter Parameter Value'' pops up for each field names I
deleted, so 10 times. I usually go in the desgin view of that form, in the
record source and delete ''Expr1...'', but this time, it doesn't work. I have
a message poping up saying ''Syntax error in query expression...'' What can I
do to delete those Expr1...????
Thanks,
Julie

 

[Michael J. Strickland]

I deleted like 10 field names in my Employees table. When I want to go
in my
Employees form, ''Enter Parameter Value'' pops up for each field names
I
deleted, so 10 times. I usually go in the desgin view of that form, in
the
record source and delete ''Expr1...'', but this time, it doesn't work.
I have
a message poping up saying ''Syntax error in query expression...''
What can I
do to delete those Expr1...????
Thanks,
Julie

Sometimes the connectivity between a table and its queries/forms gets
corrupted when you delete table fields.

I've found its easiest to re-create the query/form from scratch. If you
have complex query/form expressions you might be able to copy the query
columns or form "Control Source" entries over to the new query or form.

Needless to say, you must remove all references to the deleted table
fields from you query and form expressions.


--