Selecting multiple items to create a form

[travelmedic]

I have a little knowledge of access but I need help.



I'm trying to create a form that auto-populates an employee name and time they started based on certain criteria.

Here is an example. There are 3 different employee group numbers, but only 2 work at any time. So if a supervisor puts today's date and only group 1 and 2 are working, I only want the employees in these groups to show in a separate form. Any help would be appreciated.

[Micron]

That sounds like a tedious approach. Why not have a listbox of employees (if there are hundreds you can probably filter this list) and multi select from the list, then click some button and populate either a continuous or datasheet form below? The unbound controls you use for the search parameters would go in the form header. The results can go in the form detail section. Those records would have a field that you could enter data into. If you want to make that a checkbox field you can do that if all you want is a yes/no result, but checkbox fields are not the best for handling Nulls.

[travelmedic]

I'm trying to filter the employees who work based on if their group is working that day. I have 200+ employees and a few supervisors doing the work.

[Welshgasman]

So I would expect you need a table that holds that data in the first place?
Then when the date is entered, you look at that table and load that data into the form.?

So you would need a table for employees with a field for which group they belong to. Then you can link that table to the Workgroup table that holds the data for when any group is working.

I did something similar with employees and their working hours.
Each week, I took the default working hours for an employee and added them to the workdays table and amended as needed.

[Micron]

That means the list won't be 200 for any given day then, no? How many? You filter the list by day and/or shift/crew/role/etc. ?

[travelmedic]

No, only a 1/3 of the employees come in on any given day, give or take a few. I need to filter the list by day.

[travelmedic]

I have an employee data table with their names, group that they work, times they start, and other demographic info.