If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show all records
I have a form that has drop lists.
Users will use a list to choose an item, then the associated query will filter by that item. Two things: 1) How do I get the list to make the query show all records. The list is made up of records from another query. 2) How do I do number 1) when one form uses two lists called TimeStart and TimeEnd to tell the query to filter records between two dates. How do I make the date version show all records as well. Speaking on 1), currently when the form comes up, it has no records because the query hasn't received anything from the users to filter by. Once they choose something from the drop-down lists, the the query will refresh and show the filter records. How do I get it to show all the records. |
Thread Tools | |
Display Modes | |
|
|