Launch Data Entry Form and Carry Data

[fireytech]

I have 2 forms: Frm_FireytechCustomers and DataEntry_Fireytech

The Fireytech Customers form holds all the customer data (phone,
address, name, etc.) There is an auto generate unique customer ID
number for each customer as the primary ID.
The Data Entry form is a form we use to create a new ticket for a
Fireytech customer. There is an auto generate ticket number which is
the primary ID for this form/table.

I want to be able to look up a customer record, and click a button to
open the data entry form and carry all the customer data into the data
entry form. The only thing we would have to fill in at that point
would be the actual ticket data (what the problem is, type of machine,
etc.)

How would I do this? Please assume I am a novice and provide step by
step instructions.

 

[Bob Quintal]

(e-mail address removed) wrote in
m:

I have 2 forms: Frm_FireytechCustomers and DataEntry_Fireytech

The Fireytech Customers form holds all the customer data (phone,
address, name, etc.) There is an auto generate unique customer ID
number for each customer as the primary ID.
The Data Entry form is a form we use to create a new ticket for a
Fireytech customer. There is an auto generate ticket number which
is the primary ID for this form/table.

I want to be able to look up a customer record, and click a button
to open the data entry form and carry all the customer data into
the data entry form. The only thing we would have to fill in at
that point would be the actual ticket data (what the problem is,
type of machine, etc.)

How would I do this? Please assume I am a novice and provide step
by step instructions.

The only item of information that needs to be "carried" is the
customer's ID number.

The Data Entry form just contains the actual ticket data, but may
display the customer info by using lookups or a query filtered on the
CustomerID field.

There are several ways to pass the info, one is the openargs parameter
of the docmd.openform method.

The othre way is to make the data entry portion a subform embedded into
the customer form, and passing data via the link parent fields and link
child fields properties of the subform control.