Workaround for DataEntry=True locking ability to move between records

[accessmatt]

Hello,

I had set Data Entry to True in order to always default to a blank record. However that locked up my ability to use the arrows to navigate between records in the database. Is there a work around?

[pbaldy]

You can use GoToRecord in the load event of the form to go to a new record and still have existing records available.

[accessmatt]

pBaldy,

Thanks but I was using GoToRecord and changed to DataEntry=True because of what I describe in this thread: https://www.accessforums.net/program...ect-48581.html

Essentially it worked when I opened the form but was pushing back the last entry of the database after I used the combobox requery for the first time. Any ideas?

[pbaldy]

How about GoToRecord in the combo box code?

[accessmatt]

could you give a quick code example?

thanks

[llkhoutx]

I created a function to move between records with the arrow keys. It involved trapping the key strokes and knowing what form object was invoived. Take a look at the Key Down property, as I recall.

[pbaldy]

I meant to add GoToRecord to whatever code you have behind the combo.

[accessmatt]

@llkhoutx, I found the Key Down property but I wouldn't have any idea what code to use. Anything you can offer?

@pbaldy, this is the only code I have on the combo, could you be more explicit with how to add GoToRecord here?

Private Sub Combo71_AfterUpdate()
Me.Requery
End Sub

Thanks,

[accessmatt]

@pbaldy, I just figured it out and it worked! thank you!!

Private Sub Combo71_AfterUpdate()
Me.Requery
DoCmd.GoToRecord , , acNewRec
End Sub

[pbaldy]

Happy to help!