Hi,
I have an enquiry form frmEnquiry with two buttons, one to open frmFascia and the other to open frmSiteboard (I am trying to create a database for my son who is a sign maker). I can get the buttons to open each form at a new record and the current enquiryID if I use the datepicker on frm Enquiry, but if I set the EnquiryDate to default =date(), then the enquiry ID does not get created on frmEnquiry and so is not sent to frmFascia or frmSiteboard wwhen they are opened.
Is there any code that I can use so that EnquiryDate is entered automatically (using the default property) which produces the next EnquiryID which can then be passed to frmFascia or frmSiteboard? At the moment when I close these forms the message comes up that the record can't be saved because there is no corresponding entry in tblEnquiry.
Any help would be very much appreciated,
thanking you in advance,
jonanem
Database6.accdb