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)
 

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

Access Dcount (multiple criteria) 3
new to forms; question about 'requeries' (?) 1
iif exists - too complex? 1
Search Form Using Three Criteria 7
Multiple-criteria search on form, to open form 2
VBA: How can I use a string variable as autofilter criteria? 4
2 field find / search criteria on a form 2
List Box Paramater query with Null value 3

Back
Top