Hi
I have a form that tracks repairs to equipment and a sub form (datasheet) which displays all the various repairs to a particular item of equipment.
I am trying to have the main form update when the user clicks on a line in the sub form.
The main form and sub form are linked by a field "maintenanceitem". I have used this so it shows all records relating to that type of equipment in the sub form.
My code to update the main form form the sub form is:
Forms!FrmRepairsView.Filter = "Id=" & Me.ID
Forms!FrmRepairsView.FilterOn = True
Forms!FrmRepairsView.Requery
When I select a record in the sub form, the filter applies to the main form but then Access crashes, restarts and brings up the create backup screen!
Would appreciate any assistance with this.
Thanks
David
I have a form that tracks repairs to equipment and a sub form (datasheet) which displays all the various repairs to a particular item of equipment.
I am trying to have the main form update when the user clicks on a line in the sub form.
The main form and sub form are linked by a field "maintenanceitem". I have used this so it shows all records relating to that type of equipment in the sub form.
My code to update the main form form the sub form is:
Forms!FrmRepairsView.Filter = "Id=" & Me.ID
Forms!FrmRepairsView.FilterOn = True
Forms!FrmRepairsView.Requery
When I select a record in the sub form, the filter applies to the main form but then Access crashes, restarts and brings up the create backup screen!
Would appreciate any assistance with this.
Thanks
David