Dcount to Currentuser

[adriany]

i have print button with Dcount below to count how many
records a current user input data for if/then statment.

intStore = DCount("[IndexID]", "table1", "[userID] =
CurrentUser")

if crrentuser input 3 data and prints
i just want users to see, YOU HAVE 3(intstore) TO PRINT.

but, i get 0 everytime

 

[Gerald Stanley]

Try something along the lines of
intStore = DCount("[IndexID]", "table1", "[userID] = '" &
CurrentUser() & "'")

Hope This Helps
Gerald Stanley MCSD

 

[Guest]

thks

-----Original Message-----
Try something along the lines of
intStore = DCount("[IndexID]", "table1", "[userID] = '" &
CurrentUser() & "'")

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
i have print button with Dcount below to count how many
records a current user input data for if/then statment.

intStore = DCount("[IndexID]", "table1", "[userID] =
CurrentUser")

if crrentuser input 3 data and prints
i just want users to see, YOU HAVE 3(intstore) TO PRINT.

but, i get 0 everytime
.

.