Using pop up form to populate latest new record of a continuous form

[ali32uk]

Hi All

I have a fairly simple continous form which I am using for contacts, this is embedded subform (subformcontacts) into a master form (customer)

so I have a customer and the subform i populate with contacts for that customer.

In some cases a contact can be in multiple customers, I was looking for quick way to find the existing contact in an existing customer and transfer the information in a new record in the new customer in the continuous form.

I ve tried a pop up form, look up the existing contact through a combo box then used a command button to transfer the information with the below code onclick event, but what happens is that it overwrites the top existing contact instead of populating a new record field in the continuous forms

Forms!customer!subformcontacts!ContactName.Value = Me.ContactName.Value

would welcome any guidance as to how to do this!

Thank you in advance

Alastair

 

[dhookom]

I would run an insert SQL statement to add a record to a table rather than attempting to add a record in a form.

Duane
Hook'D on Access
MS Access MVP