J
Jim
Can an update query update an individual record without
using criteria to isolate that record? Example: As we
receive supplies, our staff indicate in the database
whether a partial quantity of an item was received. They
do so by checking an option group and entering a number in
the partial-quantity field. When the ordered quantity has
been received in full, they check the appropriate option
group. When that option group box is clicked, I want to
update the partial-quantity field to "0" for that record
only. Am I even going about this the right way?! I'm
open to suggestions...Thank You.
using criteria to isolate that record? Example: As we
receive supplies, our staff indicate in the database
whether a partial quantity of an item was received. They
do so by checking an option group and entering a number in
the partial-quantity field. When the ordered quantity has
been received in full, they check the appropriate option
group. When that option group box is clicked, I want to
update the partial-quantity field to "0" for that record
only. Am I even going about this the right way?! I'm
open to suggestions...Thank You.