I'm in the process of creating a form with lookup fields. The problem
I'm having is this: When you enter data into one of the look up
fields, the data says there. I need it to clear the field after you
hit Enter or Tab. How do I do this?? This is what is displayed 'after
update':
Private Sub Combo11_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[InvoiceNumber] = " & Str(Me![Combo11])
Me.Bookmark = rs.Bookmark
End Sub
What's missing?
inkman04 - 07 Feb 2006 19:13 GMT
Hello Linda,
No problem. Enter the following line after
Me.Bookmark = rs.Bookmark
Combo11.value = null
Just that simple.
And, if you want to go to another field on the form
just add the next line:
DoCmd.GoToControl "ControlName"
Have a nice day.
Regards
linda - 09 Feb 2006 18:37 GMT
Thanks, I had a feeling it would be something simple like that!