T
TotallyConfused
How do I remove a filter from a form automatically? I have a doc form that
lists pts assoc with doc. Upon double clicking on specific pt. I have this
code that take me to the PT FORM for this specific pt. This works fine.
However, after reviewing pt on PT FORM I want to remove filter automatically.
I tried a requery but that does not work. Can you please help. Thank in
advance.
Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "PTFORM", , , "[PTID]='" & Me![PTID] & "'"
End Sub
lists pts assoc with doc. Upon double clicking on specific pt. I have this
code that take me to the PT FORM for this specific pt. This works fine.
However, after reviewing pt on PT FORM I want to remove filter automatically.
I tried a requery but that does not work. Can you please help. Thank in
advance.
Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "PTFORM", , , "[PTID]='" & Me![PTID] & "'"
End Sub