Help with updating a record from a form field

[Guest]

I need to create a form which will take the number entered in a text field
and add it to a field in a particular record.

For example, if I have a field named "Quantity" and it has a value of 5.
The user enters 2 into a text field. The "Quantity" field should now say 7.
There is also a text box (or a drop down box. haven't decided yet) for
entering a record id number. The update will only happen for the record
specified.

I know this is easy to do with a query, and I have built an update query to
do it. It pops up message boxes to ask for the information. It won't let me
use an update query as the data source for a form.

Is this possible?

 

[RuralGuy]

What would be wrong with letting the user just change the 5 to a 7?

I need to create a form which will take the number entered in a text field
and add it to a field in a particular record.

For example, if I have a field named "Quantity" and it has a value of 5.
The user enters 2 into a text field. The "Quantity" field should now say 7.
There is also a text box (or a drop down box. haven't decided yet) for
entering a record id number. The update will only happen for the record
specified.

I know this is easy to do with a query, and I have built an update query to
do it. It pops up message boxes to ask for the information. It won't let me
use an update query as the data source for a form.

Is this possible?

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

There wouldn't be anything wrong with that but I am trying to eliminate as
many possible places for a user error. Even thought those two numbers are
easy to add, as numbers get bigger there could be the potential for addition
errors, and I would just rather not create that possibility if I can.

 

[RuralGuy]

The more you describe your problem the more it feels like you are
moving away from normalized tables. How about describing "what" you
are trying to accomplish in real world terms instead of "how" you are
trying to achieve it.

There wouldn't be anything wrong with that but I am trying to eliminate as
many possible places for a user error. Even thought those two numbers are
easy to add, as numbers get bigger there could be the potential for addition
errors, and I would just rather not create that possibility if I can.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

What I am trying to accomplish is to track the toner inventory for all of our
printers at my office. This question was refering to the aspect of adding
new inventory to the DB when it is purchased.

I have figured out how to accomplish this. As you have just stated, I was
getting away from having a normalized table. I have built another table to
track each individual purchase, then when I need to know how may I have I
simply add up all of the purchases of a particular toner and subtract the
total used of that toner.
I should have known to do this from the beginning, but I guess I didn't have
my head on straight. I had been working on other parts of it yesterday, so
when I got to this point my brain was fried.

Thanks for your help.

 

[RuralGuy]

You're back on track again. Glad I could help.

What I am trying to accomplish is to track the toner inventory for all of our
printers at my office. This question was refering to the aspect of adding
new inventory to the DB when it is purchased.

I have figured out how to accomplish this. As you have just stated, I was
getting away from having a normalized table. I have built another table to
track each individual purchase, then when I need to know how may I have I
simply add up all of the purchases of a particular toner and subtract the
total used of that toner.
I should have known to do this from the beginning, but I guess I didn't have
my head on straight. I had been working on other parts of it yesterday, so
when I got to this point my brain was fried.

Thanks for your help.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.