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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to pull a list of data from a Combo Box Option 1
Y/N Combo box 1
2007 Multi Value Check Box Lists 1
Delete record when form control becomes invisible 2
Forms & Tables with Combo Boxes 4
Combo box values for existing and new records 2
Cascading Combo boxes 2
Access Form - Lock Fields from Editing 0

Back
Top