I'm using Access 97 and i have a form which gets data from a query that
uses Three varibles (ProdNa, BatchNo, and OrderCod) to search a table.
When I run this form access askes me to input the parametervalue for
each of these varibles. When I use this form as a subForm of another
form, then when the form is for the first time it asks me to enter a
parameter for these varibles, but if I run the form anytime after it
first run then I don't have to anter a parameter value and everything
works fine. In both forms I have the varibles defined as:

Public BatchNo As String, ProdNa As String, OrderCod As String

Any help will be appreciated

subforms don't automatically refresh their underlying recordsets.
If you invoke the sub-forms Refresh or Requery methods, it will prompt
you again.

Sent via Deja.com
http://www.deja.com/