filter records to populate form on load

[rivereridanus]

I have a form called frmfilterrecordset which allows a user to input criteria for three separate fields for the next form "frmsurveyviewer" to page through one by one. On the GO button for frmfilterrecordset, the vb is:



Private Sub CMDGO_Click()
DoCmd.OpenForm "frmsurveyviewer", acNormal, , acFormEdit, acWindowNormal
End Sub

and the form that is supposed to be able to page through the corresponding records and edit them if necessary has an on load event:

Private Sub Form_Load()
DoCmd.ApplyFilter "filterviewer", "[Forms]![frmfilterrecordset]![TXTDATE]=[person].[day] And [Forms]![frmfilterrecordset]![COMBOLOC]=[person].[site]"
End Sub

I keep getting a message that this is wrong, but I don't know what to try to fix it! I've tried using [Forms]![frmsurveyviewer]![site/day] instead of [person].[site] but that didn't work either.

Any suggestions?

[June7]

Concatenate variables. Anything within quotes is a literal string.

"[day]=#" & [Forms]![frmfilterrecordset]![TXTDATE] & "# And [site]='" & [Forms]![frmfilterrecordset]![COMBOLOC] & "'"

Is site a text or number field? If number remove the apostrophe delimiters.

[rivereridanus]

Concatenate variables. Anything within quotes is a literal string.

"[day]=#" & [Forms]![frmfilterrecordset]![TXTDATE] & "# And [site]='" & [Forms]![frmfilterrecordset]![COMBOLOC] & "'"

Is site a text or number field? If number remove the apostrophe delimiters.

Thanks! This has gotten me further than I was able to get before. Site is a number, so I changed the apostrophes to #.
DoCmd.ApplyFilter "filterviewer", "[day]=#" & [Forms]![frmfilterrecordset]![TXTDATE] & "# And [site]=#" & [Forms]![frmfilterrecordset]![COMBOLOC] & "#"
However, when I tested it out, I got this message:

Syntax Error in Date in query expression '[day]=#07312011*" And [site]=#9'.

Also, does it make a difference if my [day] field is date/time type so 7/31/2011 but the txtdate is 07312011? If it does, I can change the date/time fields to numbers instead...
Is it possible that this would be because

[rivereridanus]

Nevermind. I figured it out enough to get by. Turns out that # designates date/time fields and not just number fields like I thought. I changed my [day] date/time field to a text field and put back the apostrophes, and left my [site] field as a number and took away the ' and the # for it. This works. Thank you!

DoCmd.ApplyFilter "filterviewer", "[day]='" & [Forms]![frmfilterrecordset]![TXTDATE] & "' And [site]=" & [Forms]![frmfilterrecordset]![COMBOLOC] & ""