Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    29

    Unanswered: GoToRecord function in VBA

    I'm trying to use a button command to go from one form to the matching record in another form. The initial query searches for existing customers, opening a split form to see all customers with that last name, and contact information. I want to be able to select one customer, and use the button to go to the Customer form that contains a subform of Order Details.

    I know I need to use DoCmd.GoToRecord, but I can't seem to get the syntax right. The split form is called frmSearch, the customer form is frmCustomer, the ID controls are both ctrCustomerID.

    DoCmd.GoToRecord...and then this is where I'm not sure.

    Can anybody help?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Unless you want to have other records available on that form, I'd use this:

    Open a second form to the record
    Paul

  3. #3
    Join Date
    Feb 2009
    Posts
    29
    Thank you so much!! It works perfectly.

Posting Permissions

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