How to set up a form that show past 6 months of data for a specific person + more

[snipe]

Hey guys,

I haven't had too much experience with advanced form creation.

I am redesigning the payroll program that is 10 years old and entirely based in Excel. I have imported about 12 months of the data, for our 250 salesmen. The data has about 25+ fields, but only 10 are inputted by a human.

The Main Menu form has a store selection, pay period selection (default value of the most recent), and salesperson selection. After these are chosen, the user hits the Submit button. This will bring up the input form.


This is where I need the help. I want the input form to display the past 6 months of data for the selected salesman, but have it not be editable. Below that, I want an input area for the current pay period.

I'm guessing that past 6 months will be done with a subform (which I have zero experience with), but I don't know how to get it only show specific data.

[pbaldy]

You can use a subform based on a query with a criteria on the date field of:

Between DateAdd("m", -6, Date()) And Date()

Set the appropriate properties on the Data tab of that subform's properties to make it read only.

[snipe]

Ah nice. I think I got it figured out. Appreciate the help!

[pbaldy]

No problemo!

[snipe]

So I built a new form. I linked the employee ID in the form to the salesperson selection combo box on the main menu, and disabled edits and additions, and locked/disabled all fields. When I open this form, it works great. It shows the details of the past 12 pay periods.

I inserted this form as a subform on my data entry form and linked the employee fields (also tried this with out linking anything). When I open the entry form, the subform is blank. What am I doing wrong?

[snipe]

OH! Got it. All good!

[pbaldy]

Glad you got it sorted out!