Form for Data Entry

N

newgirl

I use Access to enter information on where employees work for each day. One
employee can work up to 3 different locations in one day. I'm having trouble
figuring out how to set up a form to enter multiple locations for one
employee for one day. I set up a main form with the employee name and date
and a subform to enter the multiple locations for that employee and date. My
problem is I can't get the subform go to a new record after entering the
first location. I also can't go back to the main form to begin entering
information for the next employee
 
J

John W. Vinson

I use Access to enter information on where employees work for each day. One
employee can work up to 3 different locations in one day. I'm having trouble
figuring out how to set up a form to enter multiple locations for one
employee for one day. I set up a main form with the employee name and date
and a subform to enter the multiple locations for that employee and date. My
problem is I can't get the subform go to a new record after entering the
first location. I also can't go back to the main form to begin entering
information for the next employee

Get your *tables* right before you start worrying about Forms. Tables are
fundamental; forms are just tools to manage data stored in tables!

You'll need at least three tables: Employees (with an EmployeeID and
biographical info), Locations (with one record for each location at which
people can work), and Jobs. This table will have fields for EmployeeID,
Location, DateWorked, and any other needed info for that employee's activity
at that location. You can use a Form based on either the location table (if
you want to assign a bunch of employees to a location), or on the Employees
table (if you want to pick a person and specify where they will work), with a
subform based on the Jobs table.
 

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

Top