Hello -

I had a hard time thinking of a title to give this question. I really don't know what to call it.

I have a form called Offices, and on that form I have a cmd button called "Assign Contact". When I fire that cmd button, my "Office Assignments" form pops up.

The problem is, the officeid of the Offices Form is not appearing in the OfficeId textbox of the Office Assignments Form when it pops up.

My desire here is to scroll through my offices form and click on my assign contacts button and assign contacts for that specific office. As it stands now, I am just assigning contacts to nothing!

How can I have my assign contacts form pop up with the officeid number of the current record I am on in my offices table in the office assignments form, reflecting only the contacts of the specific office.


BACKGROUND: My offices table is relatd to my office assingments table as a one-to-many relationship, joined by nofficeid.



Any thoughts would truly be appreciated. This is vital to learn b/c I have a lot of other forms I need to accomplish the same task with.


TIA for any comments/help

Jason