Autofill field based on values from another table



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.



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