D
Darrin
Hello,
I am using an unbound combo box to display the data from
my table, one at a time based on the information entered
in the combo box, on my form. The code below should work
however I keep getting a data type mismatch error and
don't understand why.
Here is the code:
Sub cboLRA_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[LRA#] = '" & Me![cboLRA]
& "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
This is supplemented by a sub routine on the current event
for the form setting Me!cboLRA = Null.
Any suggestions?
Thank you.
I am using an unbound combo box to display the data from
my table, one at a time based on the information entered
in the combo box, on my form. The code below should work
however I keep getting a data type mismatch error and
don't understand why.
Here is the code:
Sub cboLRA_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[LRA#] = '" & Me![cboLRA]
& "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
This is supplemented by a sub routine on the current event
for the form setting Me!cboLRA = Null.
Any suggestions?
Thank you.