Displaying query value as default value

[Raito]

This is a fairly simple question, I haven't had much experience with Access and I've gone rusty on what I do know.

I've relational linked 2 tables together via a primary key "orgid" and created a form for both. When I add a record from the first form it adds the data and generates an auto number key then moves onto the second form. My only problem is obtaining the primary key for the second form. I tried creating a query to get the max value primary key which does return the value I want, but I have no clue how to get the second forms orgid to this value.

[NeoPa]

It may be simple from your side (if that's possible - I can't imagine why you'd post if it were so), but frankly it's not from here. Maybe a clearer phrasing of it with all the relevant info might help.