Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Unanswered: combo box selections

    Hi,

    I have a set of three combo boxes on a form for make, model, and part number. The first two combo boxes requery afterupdate on the last combo box which then only lists the relevant part numbers to the selected make and model.

    This all works fine, however, when I go back into the form the last combo box is always empty, the data is in the table, but not on the form. Is there a way for the last combo box to pickup the data from the table when it is opened but still be able to be changed based on the requery from the first two combo boxes?

    Thanks

    Steve

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    on the Open event of the form set the recordsource of the 3rd combo box and requery the combo box

  3. #3
    Join Date
    Jun 2003
    Location
    UK
    Posts
    15

    Smile Thats done the trick

    It worked a treat!

    Thanks

    Steve

Posting Permissions

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