Combo Box stumper!?

Results 1 to 2 of 2

Thread: Combo Box stumper!?

  1. #1
    Join Date
    Dec 1969

    Default Combo Box stumper!?

    I am trying to create a combo box setup that draws an, say employee id from one table (a employees wages table) and displays the employees name based on employee id corresponding with the employee table (this table has their details in,name,address etc). I can do this fine, what i need to do and cannot work out, is when i drop down the box i need the rest of the employees names kept in the employees table to display, i can do this with two queries but it produces the employee name twice (because it calls the employee once and writes it, then does it again when i list all employees).. SO.. hehe, my question is how do i list all employees and have the one from the other table automatically selected!!!...<BR><BR><BR>- Thanks if you can help me..

  2. #2
    Corin Guest

    Default RE: Combo Box stumper!?

    When you are looping through the recordset to fill the employees table add an if statment that decides which is selected. If it matches the choosen one write in selected if not have it leave that blank

Posting Permissions

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