check which control is active

MIFFY01MIFFY01 Member Posts: 2
I have a form which contains a Table box and a subform. At the bottom of the form I have some menu button commands to open up other forms.

If the cursor is on the Table box (i.e main form) I would like the command button to open up a form filtering on the record on the table box, but if the cursor is on the subform, i would like the command to use the record on the subform to open up this seperate form.

Can you please advice how I can accomplish this?

Many thanks


  • Options
    vaprogvaprog Member Posts: 1,130
    Try to use OnBeforeInput and OnAfterInput triggers on the Textbox control to record, when it has focus.
Sign In or Register to comment.