Trouble with string variable in custom vba function

[CurrentUser]

I have a custom function that returns the DSUM of a query field and want to use variables for the DSUM criteria.

This function works and returns the corrects DSUM calculation in the immediate window, using ?MyInvVarNeg(#1/9/2014#)

---
Public Function MyInvVarNeg(CurrentDay As Date)

MyInvVarNeg = Int(Nz(DSum("[RecCount]", "qInvIndNegVar", "[RecDate]>#" & CurrentDay & "#-.001 and [SenderID]=CurrentUser()"), 0))

End Function
---

When I change the CurrentUser() function that's in the DSUM into a string variable, I get a DSUM of zero, which is incorrect, even though I declare the variable as the CurrentUser() function in the immediate window, ?MyInvVarNeg(CurrentUser(), #1/9/2013#)

---
Public Function MyInvVarNeg(CurrentUseID as String, CurrentDay As Date)

MyInvVarNeg = Int(Nz(DSum("[RecCount]", "qInvIndNegVar", "[RecDate]>#" & CurrentDay & "#-.001 and [SenderID]=CurrentUseID"), 0))

End Function
---

The [SenderID] field that I'm attempting to match is of the Text data type in the table that is queried, and is generated by another function and defined as a string in that function.

What am I missing? Why does CurrentUser() work in this function when hardcoded, but I can’t seem to get it to work as a variable?

[June7]

CurrentUseID cannot be within quote marks. Concatentate the variable, just as you do with CurrentDay.

Why create another variable anyway? Is it populated with the CurrentUser() function?

[CurrentUser]

Thanks for the reply.
I thought it would be a good idea to write a common function for users to see their personal variance in the main form (based on their user ID) and also use the same function in an admin query to display multiple users' variance, so the variable can be the current user function or a user ID field, depending on the circumstance.

[June7]

What is 'personal variance'.

This is resolved?

[CurrentUser]

In this case, variance is a difference in inventory from that which was verified as received. This is resolved.