Show a different but related value from a field in a form

[bfriend5]

Hello,

In a form of mine, I have the user input other person's initials, but I don't want those initials showing up on the report. It's a set group of initials to work with so I have each set associated with a random 3 digit number (that I input into the table myself). I'd like to be able to have the person input the initials in the form, but have the numbers display on the report, I'm not sure how to go about doing that. Any help/suggestions appreciated. Thanks.

 

[Ranman256]

You don't need a random#.
You should have an ID key field set to autonumber. Use THAT as your 'random' #.

 

[pbaldy]

You can use a DLookup() to get the numbers associated with the initials:

http://www.mvps.org/access/general/gen0018.htm

 

[bfriend5]

You don't need a random#.
You should have an ID key field set to autonumber. Use THAT as your 'random' #.

I guess I misspoke. It's not so much a "random" number as it's assigned to the person's initials. For example, Person A is always 487, while Person B is always 928. Sorry for the confusion, but thanks for the input!

 

[bfriend5]

You can use a DLookup() to get the numbers associated with the initials:

Thanks, that looks like it should do the trick!

 

[pbaldy]

Happy to help!