How to move the focus

DataBug

Registered User.
Local time
Today, 15:20
Joined
Oct 8, 2003
Messages
14
I'm trying to move the focus from a form to a subform and can't quite figure out how to do it.

I have a calculated field on the main main form called ChkAmt which is the sum of a field called Amount in the subform.

What I want to happen is this :

After update of Amount, go to main form and requery ChkAmt then move the focus back to the subform.

I can do everything except get the focus back to the subform.

Also, is there any way to save a record using a macro ?

Thanks
 

Users who are viewing this thread

Back
Top Bottom