Displaying form records created by user and specific to a date

[sponge]

Hi,

I was wondering how difficult it would be to do the following:

1. A user opens up a form.
2. The user uses a combo box to select his/her name.
3. There is a date combo box on the form and by default, it is set to today's date. So when the user selects his/her name, the records for today are displayed. Changing the date will show only the records for the date shown.
4. The user will have the ability to add and delete records specific to the criteria chosen in the text boxes. Adding new records will only add records for the date chosen in the combo box. E.g. if he/she adds a record for today, it will only be seen when today's date is selected.

Will a subform have to be used for something like this? Or could it be done with one form using filters?

Any thoughts and/or approaches on this would be greatly appreciated.

TIA.

 

[neileg]

You need a form based on a query and a subform. In the form, set up a combo bax to select the user. I wouldn't use a combo for the date, just a text box. You can set the initial value to Date() which will give you today.

In the query, use the combo and the date text box as criteria for the query and base your subform on this query. Set both controls on the form so that the form is refreshed when either control is updated (AfterUpdate event).

See the attached.

 

[sponge]

Hi,

Thanks for the sample.

I want the users to be able to change to previous date entries.

Is it possible to have it display today's date by default but have it be a combo box where the user can select any of the "previous" dates that data was entered?

 

[sponge]

Scratch that- figured it out.

Thanks for all the help!