I wrote a data base that has basic order information as the main form (customer name, po, order date etc). There is a subform with the product type (there are 17 - 20 different types) with comments and prices on the product.
Now the problem is that I have different forms that pop up , depending on the type of product that is chosen, that ask questions that need to be answered in order to make that product.
How do i link these different forms that pop up to the main order form (to the order id number) automatically when it pops up (like defaulting the date to =date() except defaulting the orderid number on the pop up forms to the main order form's id number?
This will help me when writing my report to print the order as well.
Thanks
Now the problem is that I have different forms that pop up , depending on the type of product that is chosen, that ask questions that need to be answered in order to make that product.
How do i link these different forms that pop up to the main order form (to the order id number) automatically when it pops up (like defaulting the date to =date() except defaulting the orderid number on the pop up forms to the main order form's id number?
This will help me when writing my report to print the order as well.
Thanks
