Switching between forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top