Hi Guys and Girls
I have a main form (frmCustomerDetails) which is used to enter details on our customers, a subform in this form (frmCustomerContactDetailsSubform), which has some fields locked (e.g. Full Name, which is a concatenated field) and consequently cannot be used for adding new contacts. Lastly I have a form for adding new customers (frmAddNewContact). This form is set to data entry, and is not for editing existing contact records.
Forms as below
frmCustomerDetails
CustomerID (pk)
CustomerName
CustomerAccountNumber
frmCustomerContactDetailsSubform
CustomerID
Salutation
ContactFullName (which is concatenated in the query behind the form)
ContactPosition
ContactDept
frmAddNewContact
CustomerID
Salutation
FirstName
SecondName
ContactPosition
ContactDept
On my frmCustomerDetails form I have a button that launches frmAddNewContact. What I also need this to do is copy 'CustomerID' from frmCustomerDetails, and paste it into 'CustomerID' the new record in 'frmAddNewContact'.
Please note again that this is not being used to find records in frmAddNewContacts with the same 'CustomerID' as the record in frmCustomerDetails, but is solely for adding new records. This form is for data entry only.
When 'frmAddNewContact' is closed I will presumably have to get a routine to requery the 'qryCustomerContacts', upon which the frmCustomerContactDetailsSubform is based.
All help appreciated.
Thanks!
I have a main form (frmCustomerDetails) which is used to enter details on our customers, a subform in this form (frmCustomerContactDetailsSubform), which has some fields locked (e.g. Full Name, which is a concatenated field) and consequently cannot be used for adding new contacts. Lastly I have a form for adding new customers (frmAddNewContact). This form is set to data entry, and is not for editing existing contact records.
Forms as below
frmCustomerDetails
CustomerID (pk)
CustomerName
CustomerAccountNumber
frmCustomerContactDetailsSubform
CustomerID
Salutation
ContactFullName (which is concatenated in the query behind the form)
ContactPosition
ContactDept
frmAddNewContact
CustomerID
Salutation
FirstName
SecondName
ContactPosition
ContactDept
On my frmCustomerDetails form I have a button that launches frmAddNewContact. What I also need this to do is copy 'CustomerID' from frmCustomerDetails, and paste it into 'CustomerID' the new record in 'frmAddNewContact'.
Please note again that this is not being used to find records in frmAddNewContacts with the same 'CustomerID' as the record in frmCustomerDetails, but is solely for adding new records. This form is for data entry only.
When 'frmAddNewContact' is closed I will presumably have to get a routine to requery the 'qryCustomerContacts', upon which the frmCustomerContactDetailsSubform is based.
All help appreciated.
Thanks!