Update SubForm based on value of Main Form

[HotelierDream]

Hi,



I have a DB I am working on for a hotel, as some of you know.

I have taken several parts of my table and divided them into different forms and then grouped them into one navigation form as subforms. On the navigation form I have an area where the date is set, and thanks to a user here I did get a little further but basically....

How do I get these forms to either create a new record based on the entry on the main form or display record based on date selected?

I am trying to get this part done today as the client needs it by end of month. Anyone have a Christmas miracle?

See FE and BE attachments
V2.zip

[Gicu]

Can you please review the updated front-end (please re-link it first to your be in your Y:\ drive).

I tend to not use navigation forms as they are not that friendly to maintain.

EDIT: You will notice the main (navigation) form is now unbound; if you bind it to the table you are overwriting the same record everytime you enter a new Input Date.

Cheers,
Vlad

[HotelierDream]

The night audit input one. It is the nav form.