Creating an Order form

  • Thread starter Thread starter accessclueless
  • Start date Start date
A

accessclueless

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
 
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.
 

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 forms 2
Grouping Form 1
open form/subform at specific record 3
Access Passing the value to a table 1
adding records to customers order 1
Help With MS Access 4
macro help 2
Copying Records 3

Back
Top