Filter Help

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

I am having a problem with these line of codes:

Me.RecordSource = "qry_SiteConfiguration_GSM"
Me.Filter = "SiteID ='" & txtSiteID & "'" & " And [RevNumber]=" &
txtRevNumber & " And [ProjectName]='" & txtProjectName & "'"
Me.FilterOn = True

When I open the query, the record is in the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Help 10
Can't figure out why this is not working 3
Form showing as blank with no controls 4
filter form by listbox selection 1
Filtering a form with a combo box using left function 4
Filter with double-click 1
Filter Form Based on Subform Combo Field Problem 1
Dirk Goldgar help please!!! 2

Back
Top