ACCESS LOOKUP LIST (WITH COMBO CONTROL)

[ACCESS LOOKUP LIST PROBLEM]

How do i pick 2 or more fields at the same time from a base table to a
secondary table. Example, picking a Zip Code in the base table so that the
City, State, can appear at the same time in the base table

 

[Tom van Stiphout]

On Tue, 14 Oct 2008 19:45:02 -0700, ACCESS LOOKUP LIST PROBLEM <ACCESS
LOOKUP LIST (e-mail address removed)> wrote:

I'm not sure I follow your "base table to a secondary table" language,
but if you have a dropdown with zips and upon a zip selection you want
some other labels to be populated, a neat trick is to have that data
available in the dropdown, in hidden columns:
select Zip, City, State
from SomeTable

Then in the Zip_AfterUpdate event:
City.Caption = Zip.Column(1)
State.Caption = Zip.Column(2)

Now you know that zips can span more than one city, right? That would
complicate your code a bit.

-Tom.
Microsoft Access MVP