Need form to select record, add an entered value to field and upda

O

Old engineer

I would like to design a form to select a record in a table, add an integer
value to one field, and require the operator to click on a command button to
update the record. I can't seem to find how to do this. Send me in a
direction and I'm sure I can get there
 
N

NetworkTrade

an Access Form which is sourced on the table is all you need.

the user could manually type in the newer value - and that's it...the data
is live so there is no 'save' or update

- or - you could add a button and write a little vb that will increment for
them if manually adding 1 and typing it in is to be avoided i.e. in the
OnClick Event of this new increment button:
Dim NewMath as Integer
NewMath=me.textboxname + 1
me.textboxname=NewMath

hope this helps
 
O

Old engineer

Thanks, got it.

The button is important to the application. I had tried this but received
an error from an unrelated problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top