Multiple Form Access VB Problem, Help Please

[LonC25]

I have a 3 form vb application for looking up Quality documents. On the first form you can choose "open" and that accesses a second form that will ask you for the Form # in a text box. I need to then open a third form to show all the revisons of the form number entered.

I have a dat object on the 3rd form that points to the .mdb file.

So I guess I need a query that will show me records on the 3rd form based on text entered on the second form.

Please help

 

[jonathanmb]

You can share information between forms.

Here are two ideas just off the top of my head...

1.) Since Form2 is loading Form3, just put in the Form_OnLoad of Form3 to retrieve the information from the txt box on Form2.

or

2.) You can have a public subroutine in Form3 that is used to open the form which also accepts an argument. Then Form2 can call that subroutine and also pass it the information it needs to share.

--
Jonathan