Auto update a field in a table

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

Guest

I have a main table that keeps track of project information. One of the
fields is Status and tracks the the project as it passes through different
phases. What I would like to do is update this status field as certain forms
are filled out. For example I have a form for Quality Testing results (who's
information is housed in a Quality Testing Table). When the user fills out
this form and clicks "Ok" then I would like to automatically update the
status in the main table to Quality Testing Done. What is the easiest way to
accomplish this. Thank you in advance for the help.
 
You can use the AfterInsert or AfterUpdate of or the Form "Quality Testing"
or the cmdOK_Click Event to run an Update Query (or DAO code) to update the
Status Field of the tblProject.
 
Which of these two options provides the best performance? And how would I go
about doing it? I would like to add the code/run query to the cmdOK_Click
event.

Thanks for your help
 
Update Query generally more efficient if you want to update multiple
Records. In your case where you likely to update only one Record, either
will be fine.
 
Back
Top