Autofill field based on 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.
 
D

Dennis

If I understand you correctly (and I'm not at all certain that I do), you can
make the control a drop-down whose Row Source is the table you want to use.
Set Limit to List = Yes and you should be fine.
 

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

How to Autofill a field based on a table of values 7
Deleting records based on another table 1
Summarizing control based on unique values different field 1
Calculate values of 2 controls based on the values of 3 other cont 3
Autofill ID fields 6
Howto make Combobox requery based on dependant combobox values 1
Using an autonumber as a Record ID 18
Copy a Single Field From Multiple Records & Paste Into Another Table 1

Top