Creating new record in another form based on autonumber in currentform

[barrynichols]

Hi there

I have an autonumber field which is the primary key in one form
(shopper). I want to include a button in this form to create a new
record in another form (visit) without having to go and enter the
shopper details into the new form.

Any ideas?

 

[Klatuu]

First, forms do not contain data. Only tables contain data. Forms only show
the data and provide a way to manipulate it. If the visit form is based on a
different table or a query on that table, what you will need to do is to
create an append query that will append the data in the table used by the
visit form and execute it in the shopper form.