Hey Guys,
Back at it with some VBA mischief...Looking for a little help on syntax with an OnClick event that is not firing very well/at all.
I have the mainform (Mission Control) and two sub-forms (AuditClicksMC) and (Current-User)
I've wanted to filter the (AuditClicksMC) based on the OnClick event of the (Current-User) and have tried the code below, the code has only worked well 1 time. Every other time it has asked me to enter the parameter, the parameter field name being the value that I am trying to use as a filter...How do I apply the field.value directly as the filter?
Ive tried and (Me.logged_In) and (me.Logged_in.Value)
[Forms]![Mission Control]![AuditClicksMC].Form.Filter = "User =" & Me.Logged_In
[Forms]![Mission Control]![AuditClicksMC].Form.FilterOn = True
Any suggestions?
Back at it with some VBA mischief...Looking for a little help on syntax with an OnClick event that is not firing very well/at all.
I have the mainform (Mission Control) and two sub-forms (AuditClicksMC) and (Current-User)
I've wanted to filter the (AuditClicksMC) based on the OnClick event of the (Current-User) and have tried the code below, the code has only worked well 1 time. Every other time it has asked me to enter the parameter, the parameter field name being the value that I am trying to use as a filter...How do I apply the field.value directly as the filter?
Ive tried and (Me.logged_In) and (me.Logged_in.Value)
[Forms]![Mission Control]![AuditClicksMC].Form.Filter = "User =" & Me.Logged_In
[Forms]![Mission Control]![AuditClicksMC].Form.FilterOn = True
Any suggestions?