How do I pass values between forms?

[redhat_25]

For example:

I have a form A, which displays Customer data including Company name. User enters Company and on Lost Focus event I display form B, which shows the Datagrid with all customers for this company.

So, how do I pass the value of txtCompany.text from form A to form B as a parameter that I can include in SELECT statement.

I appreciate any suggestions.

[Pc_Madness]

Why are you doing it on Lost Focus?

[redhat_25]

Well, I thought, after user types company name, the next thing to tab. What are the other options: command buttom? And it is not critical right now. I don't know how to tie two forms together by value. Please advice me on that.
Thanks.

[Ed Lampman]

The easiest way to pass the value is to set up a Public variable in form B for this.

In Form B declarations:
Public strCompany as String

Private sub Form_Load()

(your SQL statment would be here to load the grid using strCompany)

end sub

Then, however you decide to send the value, just set it like this in form A:

With FormB
     .strCompany = FormA.txtCompany.Text
     .Show
end with

[redhat_25]

Thank you, Ed.