Cloning a record except substitute foreign key value

J

Jody

Hi All,

A subscriber can have many addresses. Can anyone suggest the code to duplicate a record in the address table with the exception of the primary key value Address ID (of course) and a substitute value in a foreign key field - SubcriberID. I have an address for one subscriber that I'd like to clone or 'auto-fill' for another subscriber who lives at the same address.

When a second Subscriber ID is selected from a combo field as part of the first Subscriber record, the after update would execute this code. An alias of the subscriber table is related to the subscriber table.

Thanks,
Jody
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate record in Form and Subform 0
Cloning a record 2
Allen Browne's Duplicate Record Code 7
Copy Master and Sub record to an exisiting record with specified P 15
Foreign Key problem 2
Duplicating error 2
Adding records - automatic numbering with two primary keys 2
Lookup current record with ComboBox, any changes create new record 3

Top