M
Matt R.
(MS Access 2007)
I have four drop-down boxes on this form that identify the name of a utensil
that someone will be using at each "station." Also I have one text box that
requires a user to input an amount (number) of times they used these items
together.
So let's say I have Four Cups labled A thru F on my table but I use A thru
D. Each drop down looks like this:
Station 1 Drop Down = Cup "A"
Station 2 Drop Down = Cup "B"
Station 3 Drop Down = Cup "C"
Station 4 Drop Down = Cup "D"
The text box wants to know how many times I cycled the cups (filled then
emptied). I put 15.
I want the number 15 to append to each record what has already been there,
so let's say cups A thru F in this table are listed all with 10 cycles. Now,
cups A thru D are +15 (25 total) cycles now and E & F weren't used so their
number doesn't change from 10.
How do I get that text box number to update one column in each row I have
selected via drop down elsewhere on the page?
I have four drop-down boxes on this form that identify the name of a utensil
that someone will be using at each "station." Also I have one text box that
requires a user to input an amount (number) of times they used these items
together.
So let's say I have Four Cups labled A thru F on my table but I use A thru
D. Each drop down looks like this:
Station 1 Drop Down = Cup "A"
Station 2 Drop Down = Cup "B"
Station 3 Drop Down = Cup "C"
Station 4 Drop Down = Cup "D"
The text box wants to know how many times I cycled the cups (filled then
emptied). I put 15.
I want the number 15 to append to each record what has already been there,
so let's say cups A thru F in this table are listed all with 10 cycles. Now,
cups A thru D are +15 (25 total) cycles now and E & F weren't used so their
number doesn't change from 10.
How do I get that text box number to update one column in each row I have
selected via drop down elsewhere on the page?