Switching between forms

P

Poul Erik Jacobsen

I have a set of forms I will use for handling datasheets on chemicals.
Each for contains a list of all the parameters in the 16 bullet datasheets.
What I would like is when I have filled out the first form and go to the
next form, I want it to automatic to write the Brand name into the next form
The brand name is unique.
 
A

Al Camp

Try this on the Click event of your form2 open button...

Private Sub cmdOpenForm2_Click()
DoCmd.OpenForm "frmForm2"
Forms!frmForm2!BrandName = Me.BrandName
End Sub

Al Camp
 
Top