Data Change (1 Viewer)

[krc547]

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?

 

[CJ_London]

a form to allow a user to select a date and it will show the data input for that day

Certainly possible, use the where parameter of docmd.openform

change the data if incorrect?

User could change the data, but it won’t happen automatically

 

[krc547]

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.

 

[jdraw]

Show us some sample data.

 

[krc547]

So the highlighted yellow field won't let me select just a single date to see instead of looking through the whole database.

 

[mike60smart]

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

 

[krc547]

OK I think I am tracking now. Thank you.

 

[theDBguy]

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.

 

[MajP]

If you want to make this filter more robust, here is a low code option

The Most Powerful form Filter and Requires almost No Code

NOTE: See updated code below. I recommend using the updated class module that @arnelgp modified. It further simplifies building a search form and addresses some bugs...

www.access-programmers.co.uk