Updating an integer value

I want to create a form to update an integer value in a table. I have a table
with parts inventory data and I want to create a form to search for a record
and update the number of parts only on that record, can I do this without
writing code or if i do what is the syntax, could someone give me an example.

Yes, you can do that, use the form wizard to create the form. Then just use
the standard navigation controls to get to the record you want, then update
the value.
The record actually gets updated as soon as you either navigate to another
record or exit from the form.
You cannot really hope to do much useful with Access unless you receive some
training or at least work through an introductory book on the subject.

-Dorian

"Leonard2k6" wrote:

I want to create a form to update an integer value in a table. I have a table
with parts inventory data and I want to create a form to search for a record
and update the number of parts only on that record, can I do this without
writing code or if i do what is the syntax, could someone give me an example.

mscertified answered the basic question. If you want to do search without
having to read through each record, create a combo box control on your fomr
using the wizard. It will guide you through creating a combo that will find
a specific record for you.

Also, I agree with mscertified that you will want to do some study and
perhaps get some training to get the most out of Access. One way to start is
to study the code created by the wizard.

"Leonard2k6" wrote:

I want to create a form to update an integer value in a table. I have a table
with parts inventory data and I want to create a form to search for a record
and update the number of parts only on that record, can I do this without
writing code or if i do what is the syntax, could someone give me an example.