Data Change

krc547

Member
Local time
Today, 13:12
Joined
Sep 1, 2023
Messages
38
Is there a way to create a form to allow a user to select a date and it will show the data input for that day and change the data if incorrect?
 
I have a form that shows all the data in that table, but I can't get the select a date field to work to show just that date from the table.
 
Show us some sample data.
 
Screenshot 2023-09-27 082924.png

So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.
 
You normally have a table that Contains a list of Dates and a table that contains details of the various Routes

You can then create Min Form based on the Dates Table
With a Subform based on the Routes table.

You can then put a Search Combobbox in the Header of the Main Form that allows you to select a specific Date

The subform would then display the various Routes for the Date Selected
 
So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.
Can you show us the Row Source query for that combobox? Try adding DISTINCT to it.
 
If you want to make this filter more robust, here is a low code option
 

Users who are viewing this thread

Back
Top Bottom