Change User ID

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

On my form I have a field called "StatusUpdate" and a button that is
called"Bidder". When the button is clicked, it captures the users ID and
displays it in the StatusUpdate field. What I would like to do is give the
user a private ID so that when the button is clicked, it will display the
Private ID assigned instead of the acutual user ID. Is there a way to do this
maybe like an IF..Then statement or something? I was thinking something like
If Statusupdate =A then Statusupdate=B not exactly of course but just giving
a quick visual.

Any help would be appreciated.

Thanks!!!
 
why not make a table to store the UserID and the PrivateID?

*UserIDs*
UserID
PrivateID

then, on your form, make UserID a combobox:

ControlSource --> UserID
RowSource --> SELECT UserID, PrivateID FROM UserIDs ORDER BY PrivateID
ColumnCount --> 2
ColumnWidths --> 0;1.5
ListWidth --> 1.5

then, PrivateID will show but UserID will be the bound field

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal,

Thank you for replying back. It is a good idea however, it's for an auction
database so I would not want the user to input the name. Currently, when they
click the bid button the database is capturing their logon ID and the field
is disabled and once the button has been clicked, that is disabled as well. I
could make another field and do a lot of if....then coding but I thought
there would be an easier way. Any other suggestions?

Thanks!!
 
Hello,

make the combobox hidden. Once they input the userid into a textbox,
because that is also the ControlSource of the combo, it will be on the
correct name.

Then, to get information from column 2, since column indexing starts
with 0, in code you can refer to the name like this ...

me.combobox_controlname.column(1)

in a calculated control:

ControlSource --> =combobox_controlname.column(1)

Since you have the UserID, you would never need to store the name again
since it can always be looked up


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top