Please help!

[buienxg]

Hi,

I am trying to incorporate dates into my database but it is driving me mad. I cant get anything to work.

I am making a database that will be used for audits and what i want is to go in and enter in the customer name and the date once, at the top of the page then work my way through all the forms I have in tab control.

I cant get the date to enter in or function correctly, so that once it is entered in, the records made to all the forms that day, are recorded as that date to.

Please someone help

[Toyman]

You have to set the default setting property for each form to refer to the date in the master form. Lets say your master form is named "MasterForm" and the date field in it is named, "ReportDate". In each of your sub forms, set the default value for their date field to [Forms]![MasterForm]![ReportDate]. When a new record is made, the date field in the sub form will take on the date value set to the default value