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.
"amiliab" <(E-Mail Removed)> wrote in message
news:0D4C1A2B-A2C7-420D-8167-(E-Mail Removed)...
>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.
>
|