Hello,
I have been trying to do this for a few days now and have searched this forum with marginal success. I am trying to return values in my subform that are within a range of stations (its a road corridor and the stations are every 100 ft.) For example I want the user to use a drop down menu to choose the southern and northern margins of the alignment and for all of the data within that range to show in the subform which is based on a table where every record has a station value.
I messed around with filtering but it isnt exactly what i need to do since the users will want to search for a range of values.
I feel like I am really close but just missing a few things. I was thinking that maybe the best way to do it would be to base it off of a query that prompts the user for station ranges instead of the drop down box...
Any help would be very, very appreciated.
Thanks,
Abby
I have been trying to do this for a few days now and have searched this forum with marginal success. I am trying to return values in my subform that are within a range of stations (its a road corridor and the stations are every 100 ft.) For example I want the user to use a drop down menu to choose the southern and northern margins of the alignment and for all of the data within that range to show in the subform which is based on a table where every record has a station value.
I messed around with filtering but it isnt exactly what i need to do since the users will want to search for a range of values.
I feel like I am really close but just missing a few things. I was thinking that maybe the best way to do it would be to base it off of a query that prompts the user for station ranges instead of the drop down box...
Any help would be very, very appreciated.
Thanks,
Abby
