Opening a Cbo and selecting automatically

[scottemotive]

Hi Long time no post,

I have form attached, which i want to cycle through all the existing records in the table it is bound to,

i then want it to on each existing record automatically drop down the cboEmployee box and select the entry that is already selected and then move on to the next record

what i mean by select the entry that is already selected:
the cboEmployee, Manager and Department box are kind of linked and if the data in the tables employee manager and department change i want it to also change pre-existing records with this data, and the only way i can think of doing it is going through each record and click on cboEmployee and selecting the employee name that is already showing, this then updates cboManager and cboDepartment, i need either help with a solution to updating pre existing records when the data tables change or an automated way of going through the attached form droping down the menu and clicking the name aready selected and going on to the next record (like an excel macro)

Your help on this matter would be appriciated
thank you

 

[Pat Hartman]

1. Your db has linked tables and they weren't included in the zip file.
2. NEVER use a form to do batch updating. Use update queries or VBA to do batch updating.

I couldn't really look at your db, but I would guess by your description that you have data residing in the wrong table. Do some reading on normalization.