Hello,
I was told that it is possible to filter a form and a subform from another form? I was told that I need to set the
forms!Formname.Filter="Query String" and then
forms!formname.Filteron=true
I have a form (frmAdd_Leak), that has a subform (frmAdd_Leak_Subform), they are attached by txtCommunity. I have another form (frmEdit) that is attached to the subform by txtLeakID.
When the user wants to edit existing data, they click on the Edit button, and the frmEdit open where they enter their name and todays date. I want when they click the okay button, that second form closes and then frmAdd_Leak is filtered to the txtcommunity, and the frmAdd_Leak_Subform is filtered to the txtLeakID.
Unfortunately, I'm new to VBA and Access and I'm not sure how to go about doing this.
Can someone please help me or point me in the right direction. As much detail as possible is appreciated.
Thanks in advance.
I was told that it is possible to filter a form and a subform from another form? I was told that I need to set the
forms!Formname.Filter="Query String" and then
forms!formname.Filteron=true
I have a form (frmAdd_Leak), that has a subform (frmAdd_Leak_Subform), they are attached by txtCommunity. I have another form (frmEdit) that is attached to the subform by txtLeakID.
When the user wants to edit existing data, they click on the Edit button, and the frmEdit open where they enter their name and todays date. I want when they click the okay button, that second form closes and then frmAdd_Leak is filtered to the txtcommunity, and the frmAdd_Leak_Subform is filtered to the txtLeakID.
Unfortunately, I'm new to VBA and Access and I'm not sure how to go about doing this.
Can someone please help me or point me in the right direction. As much detail as possible is appreciated.
Thanks in advance.
