need lookup list?

[lilakathy]

Hi, i am new and am tweaking my new form. i have a field called "drafters". we use only their initials as the value. but there are so many of them and they change often. i would like to click on a lookup list and see their whole name and their initials. then we would know which initials to type in access. i do not have to have the initials automatically go into the form. i would just be happy to know which initials go to which name and i would type it in myself.. i am confused with the combo list, lookup list and value list.. how should i go about doing this? if i could get the initials to go in the field automatically..that would be great

 

[Adrianna]

I was wondering how you would prevent users from having the same initials? If is the Initials field set to No Duplicates? Do initials and drafters full names have fields in the table or are you generating the initials from the full names be selecting the uppercase letters?

If you want to use a combo box, then run a query selecting the Drafters FullName and Initials(Unless you already have a seperate table with names and initials in a one-to-many relationship with your main table....wish would be best!).

Set the Control Source to [Initials] and the Bound Column to 2. Since your [Initials] field was in the second column of your query...it will be selected to save back to the table. So, although the users will have the full name to assist them in making their selection, only the Initials will be recorded.

Good Luck!