auto populate multiple records in subform

[PattiP]

I have a table with a list of all possible load devices that we control
during peak hours of the day. I want to keep track of the date(control
event), timeOff and timeOn for each device, which would be in a second table
linked to the devices. My dilemma is in designing the form/subform. It
seems logical to me that the main form would have the device and the subform
would list all the different days that control took place. However, there
are several (sometimes all) devices that are controlled in any one day/event.
Therefore, rather than enter the date several times and scrolling through
each device (there could be as many as 275!) I would like to enter the date
just once (main form?), then have ALL the devices show up on the subform
where I would enter the timeOFF and timeON for each. The Times cannot be in
the main form since they can vary with each device slightly as each signal is
being sent. Also, a date/control event could occur more than once if
control occurs during both a morning and/or evening peak.
Any suggestions would be appreciated!!

 

[Gina Whipp]

Patti,

Have a look at http://www.regina-whipp.com/index_files/AutoAdd.htm While it
does auto-add phone nujmbers, it can be adjusted to add whatever type of
records you like.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm