Resetting Record Source on Form

[Cheshire101]

Ok I am probably missing something obvious so any help would be appreciated....
The original record source for a form is as follows:

SELECT tblTablename.*, DCount("Field1","tblTable2","Field1='" & [Field2] & "'") AS UseCount FROM tblTableName;

The user can run a filter to change data on the form which works fine until I try and reset the record source to the above information:
I know the problem is with the “quotes”, but I cannot remember how to work around that.
I want to end up something like:

Form_MYFORM.RecordSource = “SELECT tblTablename.*, DCount("Field1","tblTable2","Field1='" & [Field2] & "'") AS UseCount FROM tblTableName;”

[RuralGuy]

Are you changing the RecordSource to something different or do you just want to Requery the original RecordSource?

[Cheshire101]

Are you changing the RecordSource to something different or do you just want to Requery the original RecordSource?

I am trying to change the record source

[RuralGuy]

I'm going to suggest a technique to achieve the results you want. Create the string as several parts that can be tested with a MsgBox or Debug.Print statements. The easiest way is to use the Chr(34) where you need a quote on the string. You could also use double sets of quotes ("") which will leave one in the string.

[Cheshire101]

Thank you..worked like a charm.

[RuralGuy]

Excellent! Glad we could help.