Date list-box?

[Courtman]

I am trying to get a list box with todays date in as a default. I would like the user to be able to increase or decrease that date, and based on what they have done re-query a number of sub-forms to show results based on the differing dates.

Can anyone please advise how to make a listbox (or something similar) automatically input dates, and then to re-query when a new date is selected (i'd probably put a "GO" button next to the date box so the re-query wouldn't go nuts).

 

[Rich]

Since it appears that you only want a single date field just use an unbound textbox

 

[Courtman]

OK, an unbound text box would work. But I want it to have "scrollbars" to the side so the user can simply click the date to increase or decrease.... can't seem to find a tool to do this in Access 2000.

 

[DES]

Date Problem

You need two controls to do this. An unbound text box whose value is set to Now() when the form Opens. The second control is the Spin Control from Microsoft Forms. Set it Max property to 365 and its Min property to -365 and make sure its Small Change property is set to 1. Then in the On upDate of the Spin control put this coding.

txtDate = Now() + spnChanger

Where the unbound text box is called txtDate and the Spinner control is called spnChanger.

That should do it for you.

 

[Rich]

Here's another way