New record when combox box is N

  • Thread starter Thread starter Joe70
  • Start date Start date
J

Joe70

I have an invoice with a combo box choice of Y or N
How do I go to a new record when the N is pick from the combo box?
 
Use the combo's AfterUpdate event procedure to go to a new record.

If Me.ActiveControl = "N" Then
DoCmd.GoToRecord , , acNewRec
End If

Brian
 
Thanks Brian, that work.

Use the combo's AfterUpdate event procedure to go to a new record.

If Me.ActiveControl = "N" Then
DoCmd.GoToRecord , , acNewRec
End If

Brian
Click to expand...
 
Back
Top