form fields... trying to return all values in a query

  • Thread starter Thread starter grantschneider
  • Start date Start date
G

grantschneider

I currently have a form and the path is [Forms]![SVP]![SVP]. I have
created a form with a drop down list that queries my main sheet for
all the possible fields. I cant seem to figure out how to write an
expression that allows me to leave it blank and then return all fields
OR choose a value and return only the matching values.

I hope this makes sense.
 

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

Query Problem--> returning wildcard 1
Querying multple criteria but allowing them to not be blank 3
problem with parameter query 3
problem with forms and queries 2
Problem with forms/parameter query 2
Form not working with query 6
Split data in field on character return 0
If statement that returns all entries or one 2

Back
Top