Hello all,
I am trying to run this code in the OnClick command of a field on a sub-form. The subform is in Continuous and displays records that are available in realtime.
This is the code:
DoCmd.OpenForm "AuditClicksUsers", acFormDS, , “User = ‘“ & Me.Logged_In.Value & “‘“, , , acWindowNormal
The AuditClicksUsers form is based on a query that is based on a Union Query.
Id like to open the form filtered by the value I click or double-click on, what am i not seeing?
Any help would be greatly appreciated.
I am trying to run this code in the OnClick command of a field on a sub-form. The subform is in Continuous and displays records that are available in realtime.
This is the code:
DoCmd.OpenForm "AuditClicksUsers", acFormDS, , “User = ‘“ & Me.Logged_In.Value & “‘“, , , acWindowNormal
The AuditClicksUsers form is based on a query that is based on a Union Query.
Id like to open the form filtered by the value I click or double-click on, what am i not seeing?
Any help would be greatly appreciated.