Problems CurrentUser function

[TJones76]

Hi!
I need to do the same thing as thread702-53601 (Inserting CurrentUser name in Form and query on CurrentUser)..but I have a problem when the User opens the form (Admin works fine)
so I'm under my login as owner of the database and here is what I have set up:

1.) Data Entry form is based on Query with field "Data Analyst" = CurrentUser
2.) OnLoad Event: DoCmd.GoToRecord, "", acNewRecord
3.) "Data_Analyst"(field properties) DefaultValue "=[CurrentUser]"

I'm getting Error# 2105 "Can't go to specific record..etc"
Then I get a completely BLANK screen on those Users that do not have any records. For the ones that DO have existing records, I get the same Error msg, then it brings up the Form but it shows the 1st record... it should be going to a NEW record based on the code I put in the OnLoad event.

How do I correct this????

Thank you so much for your help,
Tiffany



-Tjones76

 

[TJones76]

Disregard! i figured it out.. the permissions on the Query were not set up correctly for the users...needed to include ability to update and add data

-tiffany

-Tjones76