How can I set up a field that automatically inserts a letter instead of a number?
I have a form and subform linked by the FamilyMemberID (autonumber). On the subform I need a field that automatically assigns a MemberCode field with a letter. I used tabbed form with a subform on each tab for each member of the family. Each tab is titled FamilyMemberA, FamilyMemberB, FamilyMemberC, etc. Each subform has alot of different information for each family member. In order to keep the family members names hidden on reports I need to give each a field that inserts the corresponding letter from the tab. I could enter the letter in the field manually but I prefer it to automatically fill the field.
you count the Number of records in the SubForm then
ThisLetter = CHR(65+CountofSubFrom)
so when CountofSubFrom = 2
ThisLetter = "C"
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.