User information tied to "sub-form"

[spudracer]

I've got a database I'm creating that has some sub-forms actually built into the form, but there are a couple that will be stand-alones, but still take the information stored in the main form.

So, here's my question. Why won't my stand-alone forms not store the persons ID number with the record in the sub-form?

Example, I have my information in the database. I go to create a new record for say an order. I have all relationships set up AND in the query that the form is pulling it's information from I have "[Forms]![frmPersonnel]![Last Name] and .....[First Name]" as the criteria for what to pull from the query when it runs.

Problem is, it won't do that and the relationships I have set up seem to not tie in together either. The sub-form will allow me to create a new record, but it won't store it with my ID and I have to turn around and manually select my ID as the one to store it with.

Any quick and easy solution? I know I'm missing something here, because it's relatively easy, as I've done it before.

I'm using Access 2007.

 

[spudracer]

Let me shed some more light on this, because this is really kicking my butt.

Currently, I have three tables, we'll call them Personnel, Reports, and Tasks.

What I'm trying to do, and I know there has to be a way to do this, is tie the Reports and Tasks tables into the Personnel table via forms.

Each table has its own Query and Form. From the Personnel form, I'm trying to have to different buttons, one for each of the other forms (Reports, Tasks). I want to be able to create a new record within Reports form and have it store to that persons ID. So for each new report for that member, is all the info to fill out again so that no two reports get mixed up. Also, basically the same for the Tasks form.

Other than having to manually enter each persons ID so that the Reports and Tasks forms will return the correct results, what are my options?

I'm in the beginning stages of this database, so I really have no data to share, I'm simply trying to get all the kinks worked out now, before loading the data.

Both the Tasks and Reports tables have a One-to-Many relationship with the Personnel table. Even a link that will point me in the right direction for this would be helpful.