what code for beforeupdate

  • Thread starter Thread starter MER
  • Start date Start date
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?
 
Further to the other response, you need to use the LinkChildFields and
LinkMasterFields properties of the subform control of the main form.

HTH,
TC
 
Back
Top