PC Review


Reply
Thread Tools Rate Thread

Autofill field based on values from another table

 
 
amiliab
Guest
Posts: n/a
 
      25th Mar 2010
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.

 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      25th Mar 2010
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.
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Autofill a field based on a table of values amiliab Microsoft Access 7 28th Mar 2010 02:26 AM
Autofill field based on values from another table amiliab Microsoft Access Form Coding 1 26th Mar 2010 02:24 PM
Autofill field on form with values from another table amiliab Microsoft Access Forms 0 25th Mar 2010 08:39 PM
Table fields:- Setting default values to be based on other field values Rob W Microsoft Access 3 20th Feb 2008 08:51 PM
Autofill a field in one table based on another table =?Utf-8?B?TGlsYQ==?= Microsoft Access Database Table Design 13 17th Sep 2007 05:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:11 AM.