Automatically Update a Field in Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a simple form to enter just one piece of data and I need to
update a column of a table with this data automatically with a click of a
button. How do I do that? Thanks.
ck
 
Are you saying that the form is NOT bound to the table, and the control on
the form is NOT bound to the underlying field? (that would be one approach)

You could add code to the button click that updates the record in the
table...
 
Do you mean you want to update FieldX for *all the Records* in TableY with
the value entered in the ControlZ on your Form?
 
Van, that's precisely what I'm looking at. I've solved this by attaching an
update query to the button based on parameter value prompt for the user to
enter. Would you do it the same way?
ck
 
You must log in or register to reply here.

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

Similar Threads

Update Two Tables Using One Form Contents 0
Access Automatically Send a notification email once a record is added 0
Auto-update a field based on input from previous field 0
Data entry for a table from a form 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Data entry to table from a form 1
Use field to update multiple fields 4
Access Updating inventory levels 0

Back
Top