Customer details handling

[fat controller]

I have a form where customer details are required, and have arrived at the conclusion that I am best keeping those details in their own table - please correct me if I am wrong in my thinking?

Assuming this, when a new record is created, the user will be able to use a combo box to find the customer (probably with surname being the bound column), and upon selection the after update event will populate other text boxes on the form - - no problem so far.

Now, my question comes as to how a new customer is handled - if the customer doesn't appear in the list, how best to handle adding them? Am I best to have a 'new customer' button that opens a pop-up form and allows the user to enter their info. or do I have the main form append the table?

The latter would suit best I think, but how do I ensure that all fields (surname, forename, title, address, postcode and email address) are all appended back to the table, and are appended back to the right record?

 

[burrina]

I think for me I would use the OnNotInListEvent and then a PopUp Form since you are needing multiple fields to be added.

 

[fat controller]

Sounds like a plan

Is there a way to get the relevant fields on the main form to fill with the information put into the pop up, or will I have to include a control to requery the combo and have the user select again?

 

[burrina]

Here is an Example:

Private Sub Form_Open(Cancel As Integer)
Forms![frmCompNotes]![TxtDescription] = Forms![frmCompanyInformation]![EmailMessage]

Private Sub Form_Close()
Forms![frmCompanyInformation]![EmailMessage] = Forms![frmCompNotes]![TxtDescription]

HTH

 

[Mihail]

Well... the burrina's way should work but, from my experience, the user will be in doubt if he don't see the name in the list.
(By the way, why you bound the "surname" field ? You should bound the ID)
So, my opinion is to create that NewClient button in order to open the frmClients form (as popup) then, after all information about the new client are entered, requery your main form.
From now you can choose the new client from the combo.