what code for beforeupdate

M

MER

What code should I write?

scenario:
If a user has the cursor in the subform of my mainform and
advances the cursor past the new record (the null record)".

How can I write code that says:

The subform can only display children with the foreign key
that matches the "current" primary key displayed on the
main form "at the moment the user moved into the subform
area".

I think I should put that code into BEFOREUPDATE of the
subform --- am I right?
 
T

TC

Further to the other response, you need to use the LinkChildFields and
LinkMasterFields properties of the subform control of the main form.

HTH,
TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code returns no records hwenKey ID is added 14
Populate main form from subform record 0
choosing which event 0
subform selection to change detail record on mainform 2
textbox event 2
beforeupdate 4
confirm changes on main and subform 2
Duplicate record in Form and Subform 0

Top