Update Table

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

Guest

I understand in most cases it's not good to update a table based on a form
control. However, I do need to update a field in my table and need help with
this.

My form updates a control based on the user log on. This identifies who is
assigned a specific task. I need to update the Task table to reflect who was
assigned to it. The control displays the name, but does not update the
table. Several people may work on a task, but only one will be assigned to
it.

Thanks, Mary
 
Not sure why you say you should not update a table from a form. You should
ALWAYS update your tabbles through forms.

If you have a field in your table that you want to update with eh current
user, just include that field on your form and have the user make an enrty
there when they add or modify a record. You can default the value of that
field in your form to the curent user by putting an entry in the DEFAULT
of...

=CurrentUser()


Or, you can write some code to put the userid in there when a certain event
fires.
 
Rick, I already have the default value set and it displays properly, but the
underlying table does not update. I need to retain the information in the
table and I'm not sure why it's not updating. Thanks, Mary
 
Back
Top