updating a table automatically if date is the same

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

Guest

I have a form that deals with two tables one is daily tasks the other is
people working. I need the people working table to automatically enter the
same people if the date entered on the form is the same and there is already
a field of people working for that date. Any help would be appreciated.
 
Please share exactly what you are trying to do. What are the fields in
these two tables and give us an example of when this update should occur.
You say, "if the date entered on the form is the same...". The same as
what? And you say "there is already a field of people working for that
date". No idea what that means.


--
Rick B



"Updating tables with a form" <Updating tables with a
(e-mail address removed)> wrote in message
news:[email protected]...
 
Sorry about the confusion. My form has the date, time, vehicle used, jobs
performed and at the bottom the date again and people working that day. How
the form works is that I sort jobs by time so I enter a job number according
to the time that it needs done. If I do not enter the same people working on
each form my report will only print the jobs that have the people working
filled in. What I would like to have happen is if I have different jobs on
the same day after I enter the people working on the first job I would like
it to automatically enter the same people working on the remaining jobs.

Thank you for your time.
 
Back
Top