Limiting a Combo Box list through tick boxes

[dino_christou]

Hi There,

Can anyone help me with this query I have please:

I have a table in that contains employee names with various other employee details, one other detail is a tick box that indicates if the employee is still with the company or not.

I then have a form with a combo box to which links to the employee names in the above table. I would only like to display the employees that are not ticked (0 or no).

Can someone please advise me on how or if this is possible?

Many Thanks in advance.

Dino

 

[Kiwiman]

Add the field that holds the employee status to your row source of the combo box and put a 0 in the criteria section. This will retrun all records that are not ticked

If you put a -1 in the criteria section, then the combobox will only return those that are ticked

 

[dino_christou]

Thanks for the fast reply.

Now that you put the answer it all becomes clear, think I was having a silly off day.

Many Thanks for you help.