Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Forms asks for Parameter Value when opening

Status
Not open for further replies.

TimTDP

Technical User
Feb 15, 2004
373
0
0
ZA
In Access 2000 I have a form with a linked subform
When I open the main form it loads correctly. however the sub form does not finish loading and I am prompted to enter a parameter value for a field that does not exist (it used to, but I deleted it because it was no longer required). If I simply click on OK, the subform loads correctly.
If I run the query that the subform is based on, it also runs correctly.
I have tried repairing the database using the decompile command but without luck.
how do I correct this?
 
Found the problem!
The query of a combo box was looking for the field
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top