Preloaded Subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a form + subform to record the results of Building
Alrm tests.
Main form containing date, building name, etc.
Sub form containg list of alarms to be tested , working/not working check,
comment.

For each new record (main form) I need the sub to load with alarms to test
already listed. eg Alarm 1, Alarm 2, etc.

I can create this form but only with the sub not yet populated.
Your help would be much appreciated.

TIA
Duncan
 
I have main form with date and building fields

subform with alarm, working (yes/no) and comment

the alarms for each building are constant eg. alarm a, alarm b, etc. (the
actual names are a bit more complex)

I'm trying to set the forms up so that when a building is selected a unique
list of alarms are displayed in the alarm field allowing me to then tick
working or not working. (associated with a specific date)

I'm not sure it's possible to setup combination of queries that will allow
me to do this but any help or comments would be greatly appreciated.



TIA
Duncan
 
I have main form with date and building fields

subform with alarm, working (yes/no) and comment

the alarms for each building are constant eg. alarm a, alarm b, etc. (the
actual names are a bit more complex)

I'm trying to set the forms up so that when a building is selected a unique
list of alarms are displayed in the alarm field allowing me to then tick
working or not working. (associated with a specific date)

I'm not sure it's possible to setup combination of queries that will allow
me to do this but any help or comments would be greatly appreciated.
Click to expand...

I would suggest stepping back to the table design; tables are
fundamental, forms are just tools to work with the tables.

If you had an AlarmChecks table with four fields - BuildingID,
AlarmName, DateChecked, and Working - you could base your Subform on
the Alarms table. In the Master/Child Link Field you'ld use the
BuildingID and (probably) the name of a textbox containing the desired
date.

This subform would then show all the alarms for a given building for
that selected date.

John W. Vinson[MVP]
 
Back
Top