sql help (1 Viewer)

[Jediphase]

I have a combo box on a form that selects all workers

i need to select workers with a certain boss id no.

the boss id no. is held on another open form in an unbound box called bossid

I have the select from right but when i specify where workers.bossid = [form_who]![bossid] it doesnt work.

is that the right code to check a box on a form??

 

[Alexandre]

Correct syntax is:
Forms![YourFormName].YourControlName

So in your case:
Forms![Form_who].BossId