Record Selectors

[Tom]

Record Selectors:

I am using Multiple Form Tabs(pages) to do data entry, with several other
sub Forms which are tied via tied “link Child/Master Fieldâ€

Since, the user could be using one of several “pages/Tabs†I run a macro
triggered by “OnEnter†into a data field which writes the data into a common
txt box used for linking the sub forms. This all works fine

My Issue: When someone uses the “Next record†buttons at the bottom of the
form, I have nothing to trigger the maco. What code can I use to know when
these selectors are pushed?

Regards Tom

 

[Marshall Barton]

Record Selectors:

I am using Multiple Form Tabs(pages) to do data entry, with several other
sub Forms which are tied via tied “link Child/Master Field”

Since, the user could be using one of several “pages/Tabs” I run a macro
triggered by “OnEnter” into a data field which writes the data into a common
txt box used for linking the sub forms. This all works fine

My Issue: When someone uses the “Next record” buttons at the bottom of the
form, I have nothing to trigger the maco. What code can I use to know when
these selectors are pushed?

The form's Current event fires after a different record
becomes current. Most likely, this is where you where you
would set the value of the linking text box.

If the current record has been edited, then the form's
BeforeUpdate and AfterUpdate events are triggered before
moving to a different record. This is where you would do
something before leaving the current record.