Enter a value into table by command button

  • Thread starter Thread starter Annemarie
  • Start date Start date
A

Annemarie

Is it possible to enter a value into a table by clicking a command
button? I tried to use an option group but this was not compatible
with the other procedures I need the command button for.
 
Annemarie

A command button is really just a visual reminder that some procedure will
run. I am assuming you mean a command button in a form, since you wouldn't
be able to (nor want to) have a command button in a table view, as far as I
know.

You'll have to write the procedure/code that runs when the command button is
clicked. If you are talking about updating a field in an existing row in a
table, take a look at an Update query. If you are talking about inserting
an entire new row of data, take a look at an Append (insert) query. These
should give you a way to get this done.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top