Hi , I am trying to have criteria set in my query from a pop up form. My form has the following controls: [cboLocation], [startdate], [enddate] and [name]. Then I have a button that calls a report with [qrySource] as the source for the report.
I need to set my query up to accept the values from the pop up form or if the user leaves blank the query returns all records.
Can someone help with this? I am still searching the forum and I haven't found what I'm looking for yet.
I need to set my query up to accept the values from the pop up form or if the user leaves blank the query returns all records.
Can someone help with this? I am still searching the forum and I haven't found what I'm looking for yet.
