Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2003
    Posts
    18
    Thanks
    0
    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.

    Thanks
    Justin.

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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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
  •