Auto Fill Fields
in [Form]
|
From: Carlnlola via AccessMonster.com on 22 Apr 2010 10:17 Thanks for getting back to me. I already did what you suggested and just put the Last Name with first initial. Seemed the easiest way and it works for what I need it to do. Thanks again for all your help. Kindest Regards, Carl golfinray wrote: >One of the problems with using name is that there may be 4 or 5 Jones'. Can >you assign a unique ID number to each person, then search on the ID number. >You could even set up an ID like >001 Jones L >002 Jones T >003 Jones B >etc. Even better would be just to have cascading combo boxes (2) and have >a reference to the individuals, like Jones. Then the second combo you pick >T., B., or L. Look at the search feature Allen Browne has at >www.allenbrowne.com or Martin Greene at www.fontstuff.com >Good Luck! >> golfinray: >> >[quoted text clipped - 16 lines] >> >>> >> >>> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1
From: BruceM via AccessMonster.com on 22 Apr 2010 11:17 You are only deferring the inevitable if you do not use a unique identifying field as suggested. Unless the list will never grow, you almost certainly will get duplicate combinations of last name, first initial. Carlnlola wrote: >Thanks for getting back to me. I already did what you suggested and just put >the Last Name with first initial. Seemed the easiest way and it works for >what I need it to do. > >Thanks again for all your help. > >Kindest Regards, >Carl > >>One of the problems with using name is that there may be 4 or 5 Jones'. Can >>you assign a unique ID number to each person, then search on the ID number. >[quoted text clipped - 12 lines] >>> >>> >>> >>> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1
First
|
Prev
|
Pages: 1 2 Prev: Filter Form Based on Subform Combo Field Problem Next: dlookup with multiple criteria |