How to move fields from one form to another

stanger1

Registered User.
Local time
Today, 17:07
Joined
Jul 30, 2002
Messages
53
I need some assistance with my forms. Here is my situation: I have a switchboard that I can go to my active_cert form. On this form I have Agency_ID and a combo box, labeled combo30 that queries my cert_no table. I want to be able to have a control button on my active_cert form that will take me to a tests menu. From the test menu, I want to select a test form and have the fields from the active_cert form populate the Agency_id and the cert_no fields on the tests form. My problem so far is getting the combo box field (cert_no query) and the agency_no to move from the active_cert form to the tests form.
Any help would be greatly appreciated. - If more info is needed, please let me know.

Thank You in advance!
 
on the Open Event of the Test form set the fields on the Test form equal to the fields on the Active_Cert form

Example
Me.[Field Name]=Forms![Value From Form Name].[Field Name]
 

Users who are viewing this thread

Back
Top Bottom