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