Combo box in form

[Hello World]

Hi,

I'm pretty new to Access so please bear with me!

Anyway, i have a form (frmSearch). So far this happens - the user enters an employee number into the form and it searches and finds and displays that employee on a sub-form (including such details such as address, salary, etc). This form is linked back to a query and a table called tblClients.

What we are asking employees to do is to either sign up to something or not. Therefore what i need the form to do after it has found the employee is to have a combo box with the following three options 'Yes', 'No' and 'Left Blank'. So once the form has found the employee i just click one of the above options which then adds the employee answer to their record in the sub-form and tblClients table.

Can someone please outline the steps i need to take to achieve this?

Thanks

[Stingaway]

Instead of a combo box, you could add a Yes/No field to the table driven by the sub form. When the main form is selected, the field shows on the sub-form and an be clicked... not only does it save you time in mouse moves in that you don't have to click the drop down and then select the appropriate one, but it is cleaner in the database as well...