A
Allison
Access 2000, Win XP SP2
I have two forms.
Form 1 contains a combo box that performs a lookup function and displays
associated data based on a query from a table. The form is bound to the
query; the combo box is unbound.
Form 2 contains a bound text box (txtDedCode). I want to create a command
button that will capture what's currently displayed in the text box, open
Form 1, and populate the combo box in Form 1 with the data from Form 2's text
box.
In other words, I want Form 1 to be callable from Form 2 based on the text
box contents.
How would I do that?
I have two forms.
Form 1 contains a combo box that performs a lookup function and displays
associated data based on a query from a table. The form is bound to the
query; the combo box is unbound.
Form 2 contains a bound text box (txtDedCode). I want to create a command
button that will capture what's currently displayed in the text box, open
Form 1, and populate the combo box in Form 1 with the data from Form 2's text
box.
In other words, I want Form 1 to be callable from Form 2 based on the text
box contents.
How would I do that?