Hi, I have an AppointmentDate field on the main form, frmAppointment, and I want the PaymentDate field on the subform, frmPayment, to automatically show the same date in once I enter the date on the main form - but only if there is no record in the subform.
Can this be done?
Thanks.