Update Query issues....

[tim.breeding]

I'm trying to use and updated query in the after_update event of a combo box to mark a PO number as used after the PO number is selected from the drop-down list. I'm trying to generate a query in query builder to facilitate this.

This is what I have and it's not doing what i want.

This is the result:

When I enter a known PO number it should be returning the True value to the po_used field of the associate po_number field.

Any thoughts on what's going wrong?

 

[David Eagar]

Looks like it should work, unless:
The query does not pick up your criteria from the form or
It does actually update the table, but the form is not refreshing

 

[KeithG]

Did you actual run the query or just select datasheet view?