If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto populate multiple records in subform
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!! -- Patti |
#2
|
|||
|
|||
auto populate multiple records in subform
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 "PattiP" wrote in message news 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!! -- Patti |
Thread Tools | |
Display Modes | |
|
|