Autofill field on form with values from another table

A

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.
 
O

orange via AccessMonster.com

amiliab said:
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.
Click to expand...
What have you tried so far? How are your tables structured?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill field based on values from another table 1
How to Autofill a field based on a table of values 7
Creating a Chart on form from selected data in query. 0
Dynamic Naming of Form Button 3
Copy previous record into form field 0
2007 Forms - Quick Filters not working 5
autofill form with increasing number 5
Data entry to table from a form 0

Top