On Click Event For Button On Form

[Desstro]

See attached image.

Notice the button in top left, "Day/Night"

I have a 24hour a day operation where I have a crew lead on each shift, day and night. They will be filling out this form.

Instead of making 2 identical forms, can I enter code into an on click event that will switch the form from what you see in the image to a blank form?

I would want it so that when you click back, the data that was there is still there.

Possible?

If so What would that code look like?

[NTC]

All I can advise is very generic in that 'day/night' are relative terms and one must be specific in telling a db which records to display. So you must establish a method that the press of that button the db can determine which record range or time range is to be used - and then change the record source of the form to the correct records.

Probably not a whole lot of help here but that is your challenge.

It may be relatively clear cut such as selecting between 2 different criteria in the underlying query depending on the current PC time.

[Desstro]

Both Day and Night will be pulling different data from the same table.

[NTC]

Yes understood. The form is assummed to be sourced on a query. The query has criteria defining which records are displayed.

Selecting the day/night button would change that criteria.