Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    19

    Angry Unanswered: How do I move focus to the parent form?

    Hi,

    I don't know how to use VisualBasic, but I get around pretty well with Macros and expressions. This is my question:

    When the focus is in a subform, I can't figure out how to get a macro to change the focus from that subform to the parent form. I've had to create a "refresh" button on the parent form and I have to click it manually everytime I want the calculations in the subform to update.

    I've tried using a macro with
    1. "GoToControl" and referring to me.parent, or me.parent.main form (the name of my parent form), or me.parent.[Employee] (the name of the one field in the parent form).

    If the only way to do this is in a module (Or using VisualBasic) could you walk me through it?

    Sorry if I sound new at this - any help would be very appreciated!!

    Thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Forms![MyParentFormName].Setfocus

  3. #3
    Join Date
    Oct 2003
    Posts
    19
    Thanks so much! I'll try that.

    Originally posted by M Owen
    Forms![MyParentFormName].Setfocus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •