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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter requested when form closed - why?

Status
Not open for further replies.

TimTDP

Technical User
Feb 15, 2004
373
ZA
In an Access 2000 form, I have a list box. The list box recordset is based on a parameter query. The parameters are text boxes on the form, e.g dates.

When I edit VBA for the form and then close the form, I am prompted to enter parameter values. If I open the form and don't edit any VBA, the form closes without the parameter prompts!

Why?

Thanks in advance
 
It could be the VBA code - could you post it?

Ian Mayor (UK)
Program Error
Your lack of planning is not my emergency!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top