Form Template with Pre-Filled Set of Values

[chaddiesel]

One of the managers has requested to set up a form to enter the date at the top of the form and then enter in data for all the plants below for that day. I thought I could just use a form/subform combo with the date (and any other information repeated to all the plants), but the catch is, he wants a list of the plants to automatically populate when he enters a date.

The table would look something like this:

Form

Date

---------------------------------------

Subform (with all Plant names pre-filled for this date—same list each time--and allowing him to fill in Sales and On Time Delivery).

Plant___________Sales_________On Time Delivery
Indianapolis
Detroit
Memphis
Tampa

Example with data

Form

4/20/2015

---------------------------------------

Subform

Plant___________Sales_________On Time Delivery
Indianapolis_____$100000 (manually entered)_______95% (manually entered)
Detroit_________$120000 (manually entered)_______98% (manually entered)
Memphis_______$130000 (manually entered)_______99% (manually entered)

Resulting in table records:

Date----------Plant---------Sales--------------On Time Delivery
4/20/2015____Indianapolis_____$100000_______95%
4/20/2015____ Detroit________$120000_______98%
4/20/2015____ Memphis_______$130000_______99%

Any help would be appreciated as I usually would just create a sub-form with drop-downs for the plant names, but I've never started witha pre-defined list of records.

Thank You,

-Chad

 

[pbaldy]

Don't know your table structure, but you could run an append query that populated the subform's table with the date and location, using a locations table as the base.