Autofill field based on values from another table

[amiliab]

I have a form based on a main table of geographic features. However, for all
new records, I would like to have the Geography Feature ID field autofill
based on a separate table of allowable values. I would use the autonumber
format for this, however, the allowable values are a list of letter codes
(i.e. AAAA through to AAAZ). I already have several records with acceptable
codes...however I would like all future records to pull ID's from this table.

What would be the best way to go about this?
Any help would be greatly appreciated.

Thanks.

 

[Jeff Boyce]

This is about the 4th or 5th time I've seen the same post in different
newsgroups.

You may not be aware of this, but posting multiple, independent copies of
the same request in different newsgroups is not considered polite nor
appropriate use of the newsgroups. Not only does it require you to look in
many different places to see if your question was answered, it means that
the volunteers who help out here may not realize that someone else has
already answered your question, and end up duplicating each other's efforts.

It is rarely necessary to post to more than one newsgroup. If your
situation is one of the very unusual times when it is necessary, use the
"To:" or "Newsgroups" area to add the relevant newsgroups. That way, a
response/answer in one shows up in all.

Good luck

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.