User ID

[Guest]

Hello,

I have an Auction database the works fine except I am trying to simplify one
process. I have it set up so when a user clicks the current bidder button,
their Auction user ID apears. I have some If....Then statements to change
their log in ID to whatever user ID they selected. However, there are 80
people in this department and that's a lot of If...Thens. Is there a way to
create a table with two columns one for acutual ID and one for Auction ID and
when they click the button, somehow a piece of code will read the log in ID
from the network and show their auction ID in the form field?

Thanks!!!

 

[Guest]

Yes, just create a table. You answered the question yourself. Check out the
DLookup function in Access help.

-Dorian