Multiple forms selection

T

Terry

Hello,
In Access 2003, I have form A used for order analysis and form B that is
used to lookup information and supply the result back to form A.

Example: Form A textbox can receive and order number typed in and 'after
update' will requery form and up pull the order. Or, if the order number is
not know, a command button will call form B and will allow user to
browse/filter/sort data in many combinations to drill down to the order
number (which is way to messy to try to do in a combo box on Form A). Still
on form B - a command button then populates the selected order number in the
text box on form and and closes form B.

Question: What is the best method/approach to have form A 'requery' after
the result is returned to the control (textbox)? I need the form to act as if
I typed in the data.

Thanks.

Terry
 
K

Katrina

Before closing form B, but after setting text box value. Requery form A.

formA.requery

This is assuming that you are using the textbox on Form A as criteria for
you recordset.

HTH
Katrina
 
Top