Jaybird's Brain has left the building

[Guest]

Doug, I just thought I'd say thanks for trying to help me out on this topic.
It was driving me crazy. I still don't know what I did wrong, but
re-creating the subform solved the problem. Thanks to you and Doug, I now
have a better understanding of what subform behavior should be!
--
Why are you asking me? I dont know what Im doing!

Jaybird

Assuming you've got the load number as a field in the RecordSource of the
form being used as a subform, getting a value for it in the parent form
should automatically populate the field in the new record on the subform.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks, Doug. Yeah, I'm aware of that... But this field hasn't been
assigned a value yet. I wonder if I haven't conceived of this wrong...
The
way I have it set up, the query behind the subform (based on tblPartNumber
and tblOrderDetails) is linked to my mainform by the field [Load Number].
However, this field (from the table tblOrderDetails) is blank until I fill
it
in with a value. I was hoping to pass on a value from the main form as I
make my selections for the items in the load in the subform, but nothing
I've
tried is doing the trick.
--
Why are you asking me? I dont know what Im doing!

Jaybird

When you add a form as a subform, you're asked to provide LinkChildFields
and LinkMasterFields. Once you've done that, Access takes care of
synching
the two.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Jaybird" <UMUhtq5013> wrote in message
I've been burning the candle at both ends lately, and now I've found
that
I
can't think clearly about this problem. I could use some input...
What
I've
got is a form that logs all the order items that are to go into a
furnace.
This is called [HT Load Info]. It logs all the information about the
load
as
a whole to a table called [HT Load Info]. Specific information about
the
items in the load come from a continuous subform that is based on two
tables
called [tblPartNumbers] and [tblOrderDetails]. The link between the
main
form and the subform is a field called [Load Number] which is the
primary
key
for the table [HT Load Info]. So, by design, each record of the table
[HT
Load Info] is a new load. And all of the items associated with that
load
are
to be stored in the table [tblOrderDetails] referenced by the field
[Load
Number]. Makes sense to me, in my foggy logic. However, I can't seem
to
figure out how to pass the load number from the main form to the
subform
without errors. Presumably, once the load number is established in the
main
form, I should be able to pick out the load items in the subform, and
the
load number will be passed to those items programatically... Or so I
thought
in my quieter moments. Now, the time has come to put the thing
together
(I
have people waiting on this project) and I find that I'm a little
sketchy
about the important particulars, and I'm too brain fried to come up
with a
solution on my own. Does anyone have ideas?