Pulling Back all records from a Combo Box

[DAldridge]

I am Using Access 97 and need to know how to Bring back all the records from a query using a combo Box whilst also keeping the ability to select seperate groups

 

[Guest_imported]

DA -- be just a tad more specific and might be able to help you on this.

 

[DAldridge]

Ok, I am trying to create a report that is run from a form. This form has a date range and a combo box on it to make it possible to select a single Courier and then report on all their deliveries. However I also want the facility to pull back all deliveries for all couriers as well and would like to know how to be able to pull couriers back singly or as a whole

 

[bpurser]

Head over to The Access Web--Dev Ashish runs the site, and it's pretty doggone complete. You need two things: how to add "all" to a combo (go to search page, enter 'combo' and it should be one of the first items), then in the query you're using to return recs, I'm assuming you have something along the lines of

forms![formname].[comboname] in the criteria line associated with the combo. Put in

forms![formname].[comboname] or forms![formname].[comboname] is null

this is also on his site, if you search using the work Parameter.

HTH
Ben

 

[DAldridge]

What is the URL for The Access Web. I have tried searching for it but nothing is coming up

Cheers
Dave

 

[mikehoot]

http://www.mvps.org

You might also want to look up SQL UNION Queries.

For example:

SELECT DISTINCTROW Customers.Company, Customers.[Customer Number] FROM Customers UNION SELECT &quot;<ALL>&quot;,&quot;&quot; FROM Customers ORDER BY Customers.Company;

This would give you all customers and customer numbers and a row with &quot;<ALL>&quot; which would return all records.

Try downloading this sample db which has a lot of useful examples of combo/listboxes.

http://www.odc.edu/~stahlerw/CIS340/25Combo7.mdb

Good luck! B-)

 

[DAldridge]

Thanks i'll give it a try