wrong data type 2

[AQHA]

When I run this, I get
An expression you entered is the wrong data type for one of the arguments.


Private Sub Select_Exhibitor_DblClick(Cancel As Integer)
On Error GoTo Select_Exhibitor_DblClick_Err
DoCmd.SelectObject acForm, "Exhibitors"
DoCmd.GoToControl "LastName"
DoCmd.FindRecord Forms![Exhibitor Search]![Select Exhibitor], acEntire, False, acDown, False, acCurrent
DoCmd.Close acForm, "Exhibitor Search"

Select_Exhibitor_DblClick_Exit:
Exit Sub

Select_Exhibitor_DblClick_Err:
MsgBox Err.Description
Resume Select_Exhibitor_DblClick_Exit

End Sub

 

[Savil]

Try

DoCmd.FindRecord '" & Forms![Exhibitor Search]![Select Exhibitor] & "', acEntire, False, acDown, False, acCurrent

 

[AQHA]

I am now getting
Compile error:
Argument not optional
The . FindRecord is highlighted

 

[JoeAtWork]

The first single quote makes VB think everything after FindRecord is a comment. I don't think you need quotes at all, this should suffice:

DoCmd.FindRecord CStr(Forms![Exhibitor Search]![Select Exhibitor]), acEntire, False, acDown, False, acCurrent

 

[AQHA]

Thanks to both Savil & JoeAtWork...problem solved