Create a form with variables and constants

[smcnair_wtc]

hello,
i need a query/sytem of queries or preferably a vba code for this situation:

i am creating a database to use to track purchase requests for my company. basically what happens is that different departments turn in purchase requests for multiple items. Example:
Part Number Item Name Price Qty


xx-xxx-xx copy paper $5.00 1
xxxxx-xx-x pens $12.00 2
i have a data entry form set up to enter the items quickly but there is some info that will remain constant. for example the department, point of contact, and request number for this purchase request.

i want to be able to enter all the info that will apply to all records first and then enter the data that varies, and then possibly click a save button that will save the record.

i want the form to look something like this below
___________________________
Department: Warehouse
Date: 1/7/2012
Point of Contact: John Smith
Request #: 1
Part # Item Name Price Qty
77SDJF PENS $5.00 2
FDI3DE PAPER $5.00 4
SDFSDF STAPLER $5.00 1

Ideally in this exact situation i would be able to launch my "input new purchase request" form from the main menu. Then i would enter all the data that is the same, Department, Date, Point of Contact, and Request# first or last, doesnt matter. Then i would enter all the part #`s, item names, prices, then quantities. Then click save and in the table it would automatically apply the data that is the same without having to type in or copy/paste it down the form.

[ssanfu]

Look at this dB template "Order management database" at
http://office.microsoft.com/en-us/te...i:TC001018548|

It could be close to what you want.

Basically you could have a main form for the "constant" info and a subform to enter all the part #`s, item names, prices, then quantities.

Also have a look at the Northwind desktop template.

[smcnair_wtc]

roger. looks like this is going to work fine