USER ID

[Guest]

Hello,

I have a database which I am able to capture the user ID and I want to
replace it with a made up user ID (so user's identity is hidden). When the
button is clicked, it will populate the made up user ID but if another person
click the button on the same record, I want the user ID field to update with
the new user. Instead, it just show the oringinal user who clicked on the
record first. I am using a bunch of If...Then statements to change from
actual ID to made up ID and it works great if they click on a new record. but
I need it to change on a current record.

Any help would be greatly appreciated!!!!

 

[Guest]

All you need to is in the on click event for the button do something like
Me!MadeUpId = 'whatever'
But why not create and store the made up userid when the person first opens
the application? Then there will be no need to click buttons just put the
made up id in there automatically.

-Dorian