Report Combo Box

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

When selecting data to print in a report I've got a combo
box to sort for a specific location (North, South, East,
West) which is one of my table fields (Location).

How can I add a selection for All and every region will
print instead of having a separate report to print all
regions? I guess kind of like a default to print all
locations if one of the selections isn't chosen.
 
While this may not be the most efficient method, I have accomplished this by creating a duplicate report that displays all records then specifying which form to open at runtime based on the value chosen in the list box/combo box. However, if you are trying to minimize database size, this will not be your best approach.
 
You can create another selection in your combo box by using a union query
SELECT Location
FROM Locations
UNION
SELECT "*"
FROM Locations;

You can then use Like in your query or one of several other methods.
 
Back
Top