Auto-Completing Two Fields Based on Value in Another Field

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

I have three fields in my Table called "Crime":

Location
Eastings
Northings

I want to create a form where the user looks up an address in a
combo-box for the field "Location". The Table containing these values
is called "Gazetteer", and the field is called "Location". Having
chosen an Address from the list, I would like the other two fields,
Eastings and Northings to be automatically populated with corresponding
values from the Table "Gazetteer".

The Gazetteer Table is structured as follows:

Location Eastings Northings
12 High Street London 273810 538273
15 High Street London 273819 538272
21 Bridge Street London 249765 532918

Basically, how can I auto-fill the eastings and northings fields based
on the selection from the Location field?

Your help and advice much appreciated and my brain is frying.

Martin
 
Martin,
Add Eastings and Northings columns to your combo box.
Use the AfterUpdate event of the combo to update the Eastings and
Northings fields on your form...
Me.Eastings = cboLocation.Column(1)
Me.Northings = cboLocation.Column(2)
(combo columns are numbered 0,1, 2, 3, etc, so the second column is (1))
hth
Al Camp
 
Back
Top