TomJamieson
Registered User.
- Local time
- Today, 22:14
- Joined
- Jun 8, 2006
- Messages
- 50
I have a form in datasheet view. The user sees all the records laid out. there is then a text box, where they will type the ID of the record they want to work with, and press one of four buttons that link to different forms.
What i need is for the form to open up on the record that the user typed into the ID text box. So any data already entered onto that record automatically populate the fields on the form. I figured I need to use GoToRecord on the Open Event for each form. I tried using a macro, but it only allows me to go to first, last, next or previous record.
I figured the code would look something like:
I'm not even sure if that syntax is right though. Can anyone please help?
What i need is for the form to open up on the record that the user typed into the ID text box. So any data already entered onto that record automatically populate the fields on the form. I figured I need to use GoToRecord on the Open Event for each form. I tried using a macro, but it only allows me to go to first, last, next or previous record.
I figured the code would look something like:
Code:
Private Sub Form_EditRecord(Cancel As Integer)
GoToRecord (frmRecordView!txtID)
End Sub
I'm not even sure if that syntax is right though. Can anyone please help?