updating a table as soon as info is entered into a forms field

  • Thread starter Thread starter bfreeman
  • Start date Start date
B

bfreeman

Peps,

I need to update my tables as soon as information is added to eac
field in a form. I would guess it would have to be some global cod
that would refresh everything. Can anyone help?

My best,

Free
 
Why on earth would you want to do that? That means that you'd have to
create even more code to allow people to set out of the form without making
changes! Even then they'd have to remember what the original data was and
re-enter it. Access's default operations for forms are already pretty
powerful and intuitive. However, your purposes are yours so ....

In the AfterUpdate event of the relevant text boxes put

Docmd.acSaveRecord

HTH
 
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

Control if a form updates table 3
New fields in tables and forms 2
Same record/Primary key in multiple tables 0
Access Automatically Send a notification email once a record is added 0
Trying to add a field from another table on a form 1
Field Formatted % Inputs -> 0.00% 2
Refreshing Data Form in a Tab 1
the field in the access can't be updated why? 3

Back
Top