Creating an Order form

Hi,
I want to create an order form. I have my customer form. I created a button
that brings me to the order form. There, i have the list of products. What i
want is that when i push the button to bring me to the order form, it
automatically brings me there, with all of my customer information (the one i
was on in the customer form)already there.
thank you
--
P

A typical order form will be in two parts, an Order Header and an Order
Detail. The Order Header will create a record in an Order table that will
contain information about the order like Customer, Order Date, Shipping
Address, Billing Address, etc. The Order Detail form should be a subform to
the Order Header form and each row should contain information on an item
ordered, like item number, a reference to the item description in the
Inventory table, number ordered, etc.

But to answer your basic question, you can use the OpenArgs argument of the
Open Form method to pass the customer ID to the Order form and in the Load
event of the Order form, assign the received value to the control bound to
the customer ID.
--
Dave Hargis, Microsoft Access MVP


"accessclueless" wrote:

Hi,
I want to create an order form. I have my customer form. I created a button
that brings me to the order form. There, i have the list of products. What i
want is that when i push the button to bring me to the order form, it
automatically brings me there, with all of my customer information (the one i
was on in the customer form)already there.
thank you
--
P