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.
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.