Autofill field based on values from another table

  • Thread starter Thread starter amiliab
  • Start date Start date
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.
 
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.
 
Back
Top