Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: GoToRecord from subform

    I have a main form Contacts.
    In that main form I have a subform Tasks (based on a Query, continuous form).
    The main form and subform both have the text box ContactID.
    I want to use a button in subform Tasks to go to a record in main form Contacts based on the ContactID field.
    I have tried a macro with GoToRecord command. Problem is that the record number and the ContactID number are different. So, for example: it takes the ContactID no 123 and jumps to a record no 123, which ContactID is 321.

    How can I make it go from subform to a main form using ContactID?

  2. #2
    Join Date
    Sep 2003

    Set the offset in the gotorecord in the macro to go to the [Seltop] property of the subform. Though I found that the macro has to be called by the subform and not the parent as it does not work (I am using Access 97).

Posting Permissions

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