Correct -- There are no existing values (right now) and I do want to
*somehow* get information from tblBUY into is.
In that case no form would be needed at all (for that purpose). Instead you'ld
run an Append query.
I start out by requesting parts to be purchased.
On a form [frmMRTODO - Material Request To Do] I enter the part number, qty,
project and who to deliver the part to once it comes in the door. This form
writes information to a temp table [tblPOTODO].
At the risk of overemphasizing... well, no, it can't be overemphasized.
The tables ARE FUNDAMENTAL. If you're designing tables to fit your forms,
you'll be in all sorts of trouble!!! Data is stored in tables; data is moved
between tables using queries, if need be; forms *are secondary*. I fear you
may be designing the workflow around forms, and then adding tables almost as
an afterthought.
Once I have parts in my table [tblPOTODO] then I "process" them. Each part
can have up to 3 manuf associated with it and each manuf may have many
vendors that carry this part. I have a form [frmPOTODO_process]. On this
form, for each part, I choose which manuf we are going to go with for this
buy, and then which vendor we will purchase this part from. That information
then gets written to another temp table [tblBUY] and then that part is
deleted from [tblPOTODO]. The parts in tblBUY are now ready to be purchased
and I need to be able to cut a P.O. for them.
So you're going from one temp table, to another temp table, and finally to a
"real" table?
Seriously: WHY? Why not work in your real tables, using forms?
I have most of the P.O. working. My combo box VENDORNAME is only showing me
those vendors that are in tblBUY. I have text boxes that are getting the
address, phone number, etc. from another table [tblVENDOR]. If I enter
information manually, I have confirmed that the form and subform is writing
the info to the correct tables. [tblPOHIST and tblBUYHIST respectively]. I
even have all the math working out and the form is correctly calculating
sales tax, freight, subtotal, total, etc...
I am stuck on how to get my sub form to get the information from the table
[tblBUY].
That's because:
Your Subform SHOULD NOT GET ANY INFORMATION AT ALL. That's because *forms
don't contain information*.
Your *table* tblBUYHIST needs to get information.
That information might or might not need to be on the form at all; if you want
to see it, you could use a report instead, or you could just see it on a form,
or if you want to edit it after it's in the table you'ld use a form, but just
getting the data from one table into another table doesn't.
Please point me in the right direction if you can. Thank you SO MUCH!!! for
all your help.
It'd help if you post the names, primary keys, relationships and significance
of your main tables.