Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2012
    Posts
    22

    Unanswered: Automatically filling in boxes using combo boxes

    Hi guys,

    I have created a form which has 4 tabs and will contain fields from four different tables.
    what I would like is to have most of it filled in with combo boxes.
    As you can see from the image I would like to be able to select the company using a combo box then have the rest of the boxes filled in with relevant information. Is this possible and if so how will I do this?

    Regards, Kisageru
    Attached Thumbnails Attached Thumbnails orderform.png  
    Last edited by Kisageru; 10-08-12 at 10:42.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Does this help?

    Autofill
    Paul

  3. #3
    Join Date
    Sep 2012
    Posts
    22
    I'm not at work until the morning, but I'll check this out, it seems like it's what I want

  4. #4
    Join Date
    Sep 2012
    Posts
    22
    I've done what was listed on your site, however I don't know whether i've done it wrong

    In the combo box it shows everything I need however it wont update any of the other fields in the form with the relevant information
    Attached Thumbnails Attached Thumbnails Untitled.png  
    Last edited by Kisageru; 10-09-12 at 08:44.

  5. #5
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    The site lists two different methods; which did you try? What's your code?
    Paul

  6. #6
    Join Date
    Sep 2012
    Posts
    22
    I have gotten this to work by using this in the control source of the text boxes, where this will fill in the data from the first column
    =[ComboBoxName].[column](1)

  7. #7
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    So it's working now?
    Paul

  8. #8
    Join Date
    Sep 2012
    Posts
    22
    Yes it is Thanks to your site

  9. #9
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Glad it helped you!
    Paul

Posting Permissions

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