Loop thru Combobox

lundi 16 mars 2015

Is their a way to loop thru a combo, select a item, go to next record on form,and continue until their are no more records to choose from in the combo?



Let's say I have a combobox named cboemployee

with control source set to EmpID

It would show a list of employees that are available.



Criteria would be if EligibilityID were True(1) for cboemployee

tblEmployees

EmployeeID PK

EligibilityID Number , 0 or 1



Then after the loop code but before the next fire, other code runs.

Call EmpID_AfterUpdate

Loop thru Combobox

0 commentaires:

Enregistrer un commentaire

Labels