Update table with Form and Subform

[btrini10]

Hi All
I have a table called hours which is a combination of employee ID, Project ID, hours worked and Date. I am trying to create a main form on which the user selects an employee from a drop down of Employee names (from the employees table) and a date. Once that is selected, they then go to the subform and select a project, from a drop down created by the project table) and the hours worked. The user should be able to enter all projects for that one day.
Any suggestions as to how to create this. When I create a main form using the employee table, clicking in the subform creates an employee record.
Is there a way for me to have two unbound boxes in the main form that asks for the employee via a dropdown and a date. This data is then passed to the subform to update the hours table.

Thanks for any help and please ask if clarrification is needed.

 

[Docshop]

Suggest
Main form is unbound. (no record source)

Create the combo box for Employee Id (SelectEmployee)
Another combo box to list projects (SelectProject)

on Subform properties
Link Master fields to the two combo boxes (SelectEmployeel; SelectProject)
Link child fields (EmployeeId, ProjectId)
You can hide the employeeid and projectid fields on the subform, they do need to exist in the form. Any date and time additions to the subform will then have the Employeeid and ProjectID updated from the combo box selections.


As soon as you have made both selections available dates will appear.

Hope this helps