Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: Auto Fill Form fileds

    Hi! I have a form that is based on a table Customers with Customer ID as PK. On that form I have another form called orders based on orders table With Order ID as PK.

    Here my problem is when I select customer lastname from a combobox on customers form I want to auto fill all the corresponding fields automatically, including subform.

    I don't know how to do this. Could any one help me!

    Thanks In advance

    Vad
    Vad

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    Is the form and subform linked to a table or query?

  3. #3
    Join Date
    Aug 2003
    Posts
    160
    Main form is based on a query and subform based on a query.

    Thank u

    Vad

    Originally posted by michelin man
    Is the form and subform linked to a table or query?
    Vad

  4. #4
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    In the lastname criteria of the query try using this.

    [Forms]![form_name]![combobox_name]

    also add me.requery to the on change or on update event of the combobox.

  5. #5
    Join Date
    Aug 2003
    Posts
    160
    Thanks For Ur reply. I got it.

    Thankx
    Vad


    Originally posted by michelin man
    In the lastname criteria of the query try using this.

    [Forms]![form_name]![combobox_name]

    also add me.requery to the on change or on update event of the combobox.
    Vad

Posting Permissions

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