Form to Enter Data

[Vergy39]

I have a spreadsheet in excel that tracks a departments productivity. I am trying to build something in Access to do the same thing buthaving problems with creating the form. In excel it is easy to enter the data because all the names are listed and the auditor who enters the data just has to enter data and tab to the fields. In access, I have been only successful in creating a form with a drop down box that the auditor would choose the associate. I want to list all the associates on the form itself. Here are the tables that I have:

Employees - EmployeeID LastName FirstName Postion

Productivity - Date EmployeeID Received Completed Pending

Any assistance is greatly appreciated.

Thanks
David V.

 

[MStef]

As I can understand you, you need to make a MainForm on the "Employees"
table, and a Subform on the "Productivity" table. Put Subform in MainForm, link them via EmployeeID. In MainForm Default View properties put Singl Form,
in Subform put Continuous Forms.

 

[Vergy39]

As I can understand you, you need to make a MainForm on the "Employees"
table, and a Subform on the "Productivity" table. Put Subform in MainForm, link them via EmployeeID. In MainForm Default View properties put Singl Form,
in Subform put Continuous Forms.

I appreciate your response, but having problems making it happen. I am using the wizard to create this form, but when it gets to the view part, it lists the Employee id as the main form and the Productivity as the subform. I need to have the date field in the main form. I think it might be a relationship issue, but not sure. I am hunting and pecking to try to figure it out. Any other suggetions are greatly appreciated.

Thanks
David V