Default "select all" in Form

[timsayles1]

Hello all.
I am a beginner Access user when a question on how to do something. I have a form with three drop down boxes. The forms passes info to a report once you click ok. You have to select something from each of the boxes in order for the report to display anything.

I want it to default in the dropdown box to display records containing everything in the list but I cannot figure out a formula, etc to get the job done.

Any help would be greatly appreciated!

 

[phingers]

If you're trying to achieve what I think you are, then you need go to the properties of your combo box, in the Row Source, click the ... button to invoke the query builder, then design a query to 'group by' the field that you want to be a list (use the summation button to get the group by option).
Save the SQL statement in the form property when you close it and when you open the form you should see a the list when you use the combo box. Destined for Greatness or Madness

 

[phingers]

Having re-read it is clear this is not what you are after, sorry!

I think you need to amend the query to not use the form field as its criteria, then it will display everything. Have this as an alternative report option if you like, then you can still keep the criteria selected reports?

Hope this helps
Destined for Greatness or Madness

 

[CosmoKramer]

Check out my response in the following thread:

thread703-334971

Let us know if this isn't what you're looking for.....

 

[timsayles1]

Hmm. I could not get that to work correctly. I want to have the option of selecting one or all.