Currentuser Form & Calculations

[JBL]

The currentuser feature pulls up data just fine for the current logged in
user. However, all the form footer calcaltions that did work before (when I
didn't have a currentuser criteria) return an error now. What am I doing
wrong?

 

[Mike Labosh]

The currentuser feature pulls up data just fine for the current logged in

user. However, all the form footer calcaltions that did work before (when I
didn't have a currentuser criteria) return an error now. What am I doing
wrong?

Hmm -- This sounds like one of those tasty kind of issues to play with for a
while.

But what is the error message, who is the user, and are you, or are you not,
using Access Security?

 

[JBL]

I've set up security for my database (log in/password). After logging into
the database, I click on the button to open the form, it does recognize me as
the user (aka currentuser) and only pulls up my assignment - which is want I
want. (I also have basic data users as well, but I am testing this on me
first). As I said, all my calculations that were working before - now they
show up as "#Error" messages. These were simple calculations (count, sum, and
percentages). Thanks for the help.