Carrying data from form to form

gguy

Registered User.
Local time
Today, 21:23
Joined
Jun 27, 2002
Messages
104
I have a list box in a form that allows the user to pick an ID number. The companys name, address, city ect. are shown once a choice is made. A command button is available to accept the choice and open a switch board.
The switch board has several choices of tests and more than one test may need to be run on the ID that was previously chosen. When I choose a test, a form for that test will open. I need to carry the ID number from the previous list forward to this test form.

I have tried using

[test1_ID]=[forms]![select_ID]![combo1]

in the "on open" of the test1 form but without success.

Thanks in advance, GGuy
 
Okay, I'm rather new to Access and a little confused as to where to add the Openform statement.
It would seem from the brevity of your response that I should add it to the OnOpen of the test form. Some how that doesn't seem right to me.
So, if I were going from one form to another, I figure that I would add this Openform statement to the OnClick of the command button used to call the new form.
The problem is that I am not going directly to the new form but instead I am going to a switch board, do I need to create a macro to do the Openform statement when a test type is selected from the switch board? Thanks, GGuy
 

Users who are viewing this thread

Back
Top Bottom