[AccessD] Recordset based on query

On 27 Jun 2006 at 23:08, David & Joanne Gould wrote:

> Thanks, Michael.
> 
> The field type for cboSelectmember is text, so now I just need to figure out
> how to get the sql string to recognise it.

DIm strSelectMember as String
...
strSelectMember = [Forms]![frmHire_New_Members_Extend]![cboSelectMember]
...
& " WHERE (((tblHires.member)='" & strSelectMember & "' ) AND " _
....

On the last line, note the single quotes after the =  and before )


-- 
Stuart