check which control is active

MIFFY01

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

vaprog

Try to use OnBeforeInput and OnAfterInput triggers on the Textbox control to record, when it has focus.