M
Maxwell Britman
Hi,
I have searched everywhere in help and online for a solution to this
problem but to no avail.
If I give some clarification on the problem maybe that would help you
experts to help me! Hopefully!
I have a main form, with a 4 tabbed page on it.
1. Customer tab - customer info and primary product info. Button to
open form to select product and enter product specific info such as
serial no., etc. Buttons to Purchase (Save) and Cancel are on this new
pop-up form.
2. Accessories / Orders tab - Sub form linked to orders table showing
accessories purchased which works fine.
3. Sales / Account information tab - works fine.
4. Notes tab - standard memo text box - works fine.
What I would like to do is when the purchase button is clicked is to
have the product details added to the orders table - ProductID,
UnitPrice, Quantity (default to 1) and current system Date. OrderID is
an autonumber and should be generated automatically. Is this possible?
Relationships are set up and seem to be working fine.
Copy of previous post is included below for reference.
Many thanks in advance to anyone who can help.
Also, when product is added to orders table and subform, whats the
command to refresh the subform to show new order added? or will it
show automatically when user clicks on 2nd tab?
Max
I have searched everywhere in help and online for a solution to this
problem but to no avail.
If I give some clarification on the problem maybe that would help you
experts to help me! Hopefully!
I have a main form, with a 4 tabbed page on it.
1. Customer tab - customer info and primary product info. Button to
open form to select product and enter product specific info such as
serial no., etc. Buttons to Purchase (Save) and Cancel are on this new
pop-up form.
2. Accessories / Orders tab - Sub form linked to orders table showing
accessories purchased which works fine.
3. Sales / Account information tab - works fine.
4. Notes tab - standard memo text box - works fine.
What I would like to do is when the purchase button is clicked is to
have the product details added to the orders table - ProductID,
UnitPrice, Quantity (default to 1) and current system Date. OrderID is
an autonumber and should be generated automatically. Is this possible?
Relationships are set up and seem to be working fine.
Copy of previous post is included below for reference.
Many thanks in advance to anyone who can help.
Also, when product is added to orders table and subform, whats the
command to refresh the subform to show new order added? or will it
show automatically when user clicks on 2nd tab?
Max