Text Box in Form - Type [ID], get record

[pianoprodigy]

For some reason, I just can't figure out how to do this.

I have a form that has Client info fields. I want to make a box at the top of the form that the user can type in the [ID] of the record and retrieve the record by hitting enter.

For example:

Click in blank box, type "47545", hit enter, record appears in form

I know this probably is easy, but I've hit a roadblock.

Thanks

 

[Meltdown]

Put an unbound text control in the form header, in the After Update event of the text control put...

Me.RecordsetClone.FindFirst "[ID] = " & Me.NameOfTextControl
Me.Bookmark = Me.RecordsetClone.Bookmark

 

[usermj]

Put an unbound text control in the form header, in the After Update event of the text control put...

Me.RecordsetClone.FindFirst "[ID] = " & Me.NameOfTextControl
Me.Bookmark = Me.RecordsetClone.Bookmark

Referring to Meltdown post,

I find you some more detailed infor as the following:

http://msdn.microsoft.com/library/d...ry/en-us/vbaac11/html/acproRecordsetClone.asp

Sign the RecordsetClone's Bookmark to Form's Bookmark