Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking fields and autopopulating (1997)

    I have 2 forms linked by billing number and when I click the command button to go to the other form I would like the billing number on that form to autopopulate to the same number on the first form. Can this be done?

    Thanks,
    Ben

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking fields and autopopulating (1997)

    In the code for the buttom use something like :
    DoCmd.OpenForm "Myform", , , , acFormAdd, , Me.BillingNumber

    In the On Load event of the second form use :
    If Me.OpenArgs <> "" Then
    Me.BillingNumber = Me.OpenArgs
    End If
    Francois

Posting Permissions

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