Multiple forms selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top