Autofill data

Hey, is there a way to autofill some values in access based on a combination of other fields? Like essentially with VLOOKUP in excel. Specifically, I'm trying to autofill Latitude and Longitude field...

access

Access Web Database

autofill

Calculated Field

Tom_van_Stiphout
Jan 13, 2025
If I understand correctly, Waypoint should also be a combobox, and restricted to the values for the selected Bay. That is called "cascading combobox" if you search for it online.
Once you have that, then Waypoint combobox can have two additional hidden columns with Lat and Long, and those controls can have a ControlSource of:
=Waypoint.Column(2)
=Waypoint.Column(3)
Assuming Lat and Long are in columns 3 and 4.

Tom_van_Stiphout

Iron Contributor

Jan 13, 2025

If I understand correctly, Waypoint should also be a combobox, and restricted to the values for the selected Bay. That is called "cascading combobox" if you search for it online.

Once you have that, then Waypoint combobox can have two additional hidden columns with Lat and Long, and those controls can have a ControlSource of:

=Waypoint.Column(2)
=Waypoint.Column(3)
Assuming Lat and Long are in columns 3 and 4.

fishylizard

Copper Contributor

Jan 14, 2025

Nevermind, I think I got it!

Forum Discussion

Autofill data

Resources