HELP Trying to Change recordsource of form with Combo

[Shadez]

I have the following code in the on update event of the combo box.

Me.RecordSource = "SELECT BMembers.*, [BQualify].[Category] FROM (BQualifyList INNER JOIN BQualify ON [BQualifyList].[BQualify]=[BQualify].[Category]) INNER JOIN BMembers ON [BQualify].[MemberID]=[BMembers].[CustomerID] WHERE ((([BQualify].[Category])=[Combo62]));"


I am trying to filter the record source using combo62's value. when triggered though I get prompted for the data for this field. If I type in the data it works great. Why is this not finding the data in this box.

Please post an example of this fix

 

[AccessSQLUser]

Try this:
WHERE ((([BQualify].[Category])=forms![formname]![Combo62]));"
and if that doesn't work try
Dim myString as string
myString = me.Combo62
me.recordsource = "Select....Where ((([BQualify].[Category])=""" & myString & ""&quot);"

 

[Shadez]

thank you very much, your second suggestion works perfect