Form fields auto-populating

[CSJH]

I am creating a basic form using one table for entering daily hours worked per person with multiple projects. I need to have enough lines for each record for an 8 hour day which may include several projects in one day. I added combo boxes to the form and I can use the same category or different categories with no problem. My problem is the "hours worked" field. How do I have that field multiple times on the same form without it auto populating the same number to all the fields on the form? I feel like this is probably a simple answer but I can't figure it out...



Thanks in advance

[ranman256]

remove the text box default value,
or
run an update query to set the text box value after the form loads.
(it wouild update all HrsWorked=0)

[Bulzie]

Sounds like you need more then 1 table?
tblEmployee (EmpID(auto), EmpName)
tblProjects (ProjectID(auto), ProjectName)
tblProjectsWorked (ProjectsWorkedID(auto), EmpID, ProjectID, HoursWorked)
Form based on tblProjectWorked, use combo boxes to select Employee and Project. Then link all 3 in query by EmpID and ProjectID to get all data for reporting.

[CSJH]

Thank you but I still can't get the hours worked field to stop auto populating the same number for all of the fields. It seems like such a simple problem that I can't fix.

[Bulzie]

Are all the hours worked fields on the form bound to the same field (Control Source in properties) in the table? If you just copied that field multiple times, you have to go in and point to the different HoursWorked fields in your table if that is how you have it set up.

[CSJH]

I am sorry I still don't understand. I have one HoursWorked filed in my table. If I add 8 fields of hours worked to the table will that give accurate data when running reports?

[Bulzie]

Can you give an example of your data in the table and how it is on the form?

[CSJH]

Here are my tables:
Table: Employee
EmployeeID (PK) Auto Number
FirstName Short Text
LastName Short Text
Table: Funds/Projects
FundID (PK) Auto Number
Funds/Projects Short Text
FundCategory Short Text
Table: Hours
TimeLogID AutoNumber
DateWorked Date/Time
EmployeeID Short Text
FundID Short Text
TaskID Short Text
HoursWorked Number
Table: Tasks/Activities
TaskID (PK) Auto Number
Tasks/Activities Short Text
TaskCategory Short Text
I want to create a simple form each employee fills out daily, enters their name and the date.
They then have the option to use drop downs to select a fund/project and a task/activity. On the same line they need to enter time worked in half hour increments.
So it should look like this.
John Smith Week Ending 4/7/17
Coin General 0:30
Operating General 2:30
Administration Sick Time 4:30
Administration Staff meeting 0:30
Total: 8:00
I have the form the way I want it but I can't get the hoursworked fields to be separate from each other without autopopulating.

Can you please tell me if there is a problem with my tables or maybe it's a relationship problem??
Thank You!!

[Bulzie]

Your Foreign key fields in the related tables should be numeric, not text as they have to link back to autonumber(numeric) fields.

So do you have a main form to enter Name and Date, then subform to enter Project, Task and Hours?

[CSJH]

Thank you for the help, I will check that and try again.