|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I have a combo box with three fields of data from a query, and each field is from a different table. One field is an auto number and the others are text. SrvcLookUp is the combo box and ServiceID is the auto number. I keep getting a Run-time error '3464': Data type mismatch in criteria expression. What am I doing wrong?!
Here is the event procedure: Private Sub SrvcLookUp_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "ServiceID = '" & Me![SrvcLookUp] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub Any help would be greatly appreciated... /Frank |
|
#2
|
|||
|
|||
|
You saod the service ID is a Number so your find first comment is incorrectly reference. Use the following
rs.FindFirst "ServiceID = " & Me![SrvcLookUp] You can have quotes around a numeric data value S- |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > combo box to bring up record in form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|