how to open by default a subform to same ID of master form?

H

HGood

Sorry, I posted this over in Forms but realized it should have been posted
here.

Hi, I have a many to many database where a Project can have more than one
Language, and the Language can also exist in more than one Project. Left and
right arrows on the subform allow me to click thru the various Projects it
(the Language) is part of.
There are two criteria on the master form to which I'd like the subform
to open by default. The primary one is EthID, which is presently linked to
ctrlEthID on the main form. So it correctly opens by default to the EthID.
However, there's also another ID on the subform (StageProjectID) that I'd
like to have the subform open by default - to be the same as the ProjectID on
the main form. I tried linking Child to Master, but then it doesn't allow me
to click thru the other Projects that is part of.
TIA for anyone that can tell me how to have it meet this second criteria
for default opening, so that it will open to both the same EthID and same
ProjectID as on the main form. It's probably some VBA code. If it is VBA
code, which of the two forms do I place it in, Main or Sub? Also, which
event? Maybe I should have posted this over in programming.
Thanks very much, Harold
 
Top