I have a form that the user, of course, enters in various data points. One bit of data is choosing a bike route they ride. Based on what route they choose I would like the other textboxes on the form to populate with the corosponding data.
On one of the worksheets I have a table the user fills out that has the name of the route, mileage and elevation gain (20 routes).
When the form is engaged the user can choose between what route they want. Now, how can I, if I can, then have the data populate on the other textboxes for the corosponding data from that matching ride?
Thanks much in advance
Guy Gadois