Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Thanked 0 Times in 0 Posts

    GoTo Control Macro (2000)

    Hello ,

    I am trying to use write a macro using the 'GoTo Control' command which can automatically goto the record 'Iss No' which is in a sub table.
    I would be grateful if you could tell me the coding for this.
    See example1.


    (Screenshot reduced in size by HansV to prevent horizontal scrolling)
    Attached Images Attached Images

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: GoTo Control Macro (2000)

    Setting focus to a control in a subform is a two-step process:
    1. Set focus to the subform as a control on the main form.
    2. Set focus to the control in the subform.
    So you must create a macro with two GoToControl actions. Set the Control Name argument of the first GoToControl to the name of the subform as a control on the main form, and the ControlName argument of the second one to the name of the control on the subform. See MSKB article ACC2000: How to Set Focus to a Subform Control Using GoToControl.

Posting Permissions

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