Refresh form

[Guest]

I have 2 list boxes on a form that are based on queries that have parameters
which are determined/set by field values in another form.

The user clicks a commandbutton in the 1st form and the 2nd form opens up
with it's 2 list boxes which are filled from queries that are based on field
values from the 1st form. The problem is that when I refresh the 2nd form, it
looks for the parameters from the 1st form again. Is there any way of
avoiding this?

 

[Armen Stein]

I have 2 list boxes on a form that are based on queries that have parameters
which are determined/set by field values in another form.

The user clicks a commandbutton in the 1st form and the 2nd form opens up
with it's 2 list boxes which are filled from queries that are based on field
values from the 1st form. The problem is that when I refresh the 2nd form, it
looks for the parameters from the 1st form again. Is there any way of
avoiding this?

You could set hidden textbox controls on the 2nd form with the values
from the 1st form, and use those for the criteria instead. Then you
won't need the 1st form when the 2nd form requeries.