S
Steve Finlayson
I have a main form containing a field "Property" which is used to define the
location for a housing complex. This main form us used to record incident
details for the properties.Each incident has an autonumber and the incident data
is from an Incident table that contains a "Property" field and links to the main
Property table.
I have added a subform to this main form from which I want to be able to select
the actual building(s) involved in the incident. The form data source is the
Incident Building table which holds the building address, property and incident
number. The data that shows comes from a query linking the building, property
and incidents. It is this form that I need to filter, or the results of this
query, to show only the buildings from the applicible property. The form now
correctly shows the various property buildings for ALL properties that have an
incident. I would like to filter the list so that only the buildings for the
"Property" are shown, hence shortening the list considerably.
I suspect that I can do this using an event procedure but do not know how to
code it nor which event to place it on. Any help would be greatly appreciated.
Thanks
Steve
location for a housing complex. This main form us used to record incident
details for the properties.Each incident has an autonumber and the incident data
is from an Incident table that contains a "Property" field and links to the main
Property table.
I have added a subform to this main form from which I want to be able to select
the actual building(s) involved in the incident. The form data source is the
Incident Building table which holds the building address, property and incident
number. The data that shows comes from a query linking the building, property
and incidents. It is this form that I need to filter, or the results of this
query, to show only the buildings from the applicible property. The form now
correctly shows the various property buildings for ALL properties that have an
incident. I would like to filter the list so that only the buildings for the
"Property" are shown, hence shortening the list considerably.
I suspect that I can do this using an event procedure but do not know how to
code it nor which event to place it on. Any help would be greatly appreciated.
Thanks
Steve