If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Creating an Order form
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 |
Thread Tools | |
Display Modes | |
|
|