Search Criteria for All records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all,
I have a question that seems simple but I can't figure it out.
What value would be entered into a frmPopUpSearch.cmboxSearchCriteria field
if you want to show all records and not filter on any particular criteria?
As of now, I have a listbox with search criteria and a button that runs
qryTable with forms!frmPopUpSearch!cmboxSearchCriteria as the criteria.
Help?
 
I am assuming that qryTable is a query. If this is so, the use this as the
criteria --

Like "*" & [forms]![frmPopUpSearch]![cmboxSearchCriteria] & "*"
 
Try

Where (FieldName = forms!frmPopUpSearch!cmboxSearchCriteria) Or
(forms!frmPopUpSearch!cmboxSearchCriteria Is Null)
 
Back
Top