I have a main dashboard with a split form where the source is a query that displays only records with a blank field. I work at a plant where we have to check in and out trucks delivering parts. I have it setup this way so if their trailer # out is blank, it will display on the main dashboard. When they leave, just click the edit hyperlink that's in that blank field and update the record. Then it goes away to the main table. That way they don't have to scroll through hundreds of records to find the one they need to edit.
Anyway, I have searched and I think I understand how to create a search box on the dashboard that will search as you type, but this I believe would only display records where it matches the search criteria and has a blank field (based on the main query I have there). What I would like to do is if they type in the search box, I want it to search and display based on all records on the main dashboard split form. Is this a possibility or would it be easier to just place a search button on the dashboard and link it to a new split form that would accomplish the same goal?
Anyway, I have searched and I think I understand how to create a search box on the dashboard that will search as you type, but this I believe would only display records where it matches the search criteria and has a blank field (based on the main query I have there). What I would like to do is if they type in the search box, I want it to search and display based on all records on the main dashboard split form. Is this a possibility or would it be easier to just place a search button on the dashboard and link it to a new split form that would accomplish the same goal?