Forum Discussion
Autofill data
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.
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.
Nevermind, I think I got it!
Thanks! That got me a lot closer, except I'm running into the problem of, like I'll have two "Waypoint 24" (one in Windy Bay, one in Hidden Lake for example) but once I select WP 24, I still get coordinates for both locations in my Lat/Long boxes
