New record when combox box is N

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?
 
B

Brian Bastl

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

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

Brian
 
J

Joe70

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