Unbound combobox filtering or searching

[yepwingtim]

I have 3 tables

tblcodes - has the list of employee codes
tblemployees - uses the list of codes

they have a one to many relationship

how can i use an unbound combobox using tblcodes to search for employees.code in a form

it seems to grabbing the tblcodes.id instead of tblcodes.codes from the unbound

im using the applyfilter macro
________
Mercedes-Benz Conceptfascination Specifications

 

[HiTechCoach]

I have 3 tables

tblcodes - has the list of employee codes
tblemployees - uses the list of codes

they have a one to many relationship

how can i use an unbound combobox using tblcodes to search for employees.code in a form

it seems to grabbing the tblcodes.id instead of tblcodes.codes from the unbound

im using the applyfilter macro

Did you use the combo box wizard to create this?

 

[yepwingtim]

ah nvm my bound columns were directing to the ID and not the codes

Thanks~
________
FERRARI F2005