Just a thougt - try changing your list box to a combo box and in the "other" properties for the combo box make sure to say "yes" to "ALLOW AUTOCORRECT". I use this method a lot to get the result you are looking for.
You might also try to set up a relationship that enforces refential integrity and check to cascade update and delete related records. Then in the main table you have the auto number field and the sub table has a field that is number / interger. Make sure the relationship is joined between these...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.