Filter Query from a Form Combo How to

[Ste4en]

I attached a small example. Its a simple problem but I just don't know how:

It has one table, one form and one update query.

The form has one combo box based on the table.

When I select the Combo field value and press the button I want to run the update query filtered for the selection.

Thanks

 

[Jon K]

Switch the query to SQL View and add a Where Clause:-

UPDATE tblpeople SET tblpeople.Placed = True
WHERE tblpeople.ID=Forms!frmPlacePeople!Combo0;
.

 

[Ste4en]

Thank-you very much.