Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Access 2007 Opening Forms with VBA

    I have a form with a subform and subsubform

    I have previously used a macro button on the subform to open the subsubform on the form (not the subform). Setting up the macro button allows me create a link between the subfrom and the subsubform.

    I'd like to avoid using buttons and instead use VBA to open the subsubform by using a get focus event procedure related to a field on the subform.

    Can anyone help please

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Not sure to understand but a control in a subform that is not open cannot receive the focus.
    Have a nice day!

Tags for this Thread

Posting Permissions

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