Managing a standalone form tied to main form

[spudracer]

I've got a main form (frmPersonnel) with the the record ID as a clickable action.

When a user clicks on the ID, another form opens where they can add specific information for that record alone.

I have two tables (tblPersonnel and tblLocalInfo) that are linked via relationships. Everything looks nice via queries, but when I go to open the "sub-form" (frmLocalInfo) it retrieves absolutely no data from the main form and saves it as a new record bringing none of the existing data from the main form with it.

At this point, I'm lost. I've done this before but I'm drawing a blank as to what I'm not doing to make this work. Not every record in the database will have a record for the sub-form.

 

[GinaWhipp]

Sounds like it might be opening for new data entry only. What is the line you are using to open the new Form?

 

[spudracer]

I'm using a macro (I know) for opening the other form with a WHERE clause for matching the ID in the record to the ID in the sub-form. Only problem is, like I said before, not everyone has a record in the second form. I'm guessing I'd need to make a tempvar for the second form to store the person's ID.

I've taken a different route with it, simply because there's more simplicity in having a sub-form apart of the main form vice having it operate separately (there's no added bonus to having the form standalone anyway).

 

[GinaWhipp]

Well, as long as you got something that works... that's all that counts!