Placing User-selected Date onto Form

[indyaries]

Greetings,

I want the User to be able to either input or select a Month for a Form.

I have an unbound Form that displays a lot of data using DCount. I also have a report that is based on a parameter query. I've been able to take the dates from the parameter, and place them in text boxes on the report.

The Form is where I would also like to place the Month that the data are applicable to.

I've used a List Box, and populated it with the Months. However, the Month selected does not stay on the Form when it's closed then opened. It also does not print. The List Box does show on Print, but it's blank.

Any ideas??

Thanks In Advance.

Bob in Indy.

 

[jimbrooking]

Bob,

If I understand your problem, how about defining a small (one field, one row) table, and using it as the unbound form's recordsource. The list box could be tied to the table's field. Whenever the form is closed, the month would be saved in the table. When the form is reopened the previously selected month would be restored in the list box.

If your report is also unbound you could set its recordsource to the same table, etc. Or you could set the value in the report using DLookup("Month","tblListBox").

Jim

 

[indyaries]

Thank you Jim! I'll give it a try.