I am submitting some data to the database. For the most part it is all text box entry. However I have one field that requires the user to select one of three locations.

I thought the easiest way to do this would be to create an option group with all three entries and then just grab the value of the Option Group at the time of submission.

I have since found out that it is not that easy, unless I am missing something obvious. I have done a search on this forum but was more confused afterwards.

I have an option group named gbLocationSelection with three choices:

Control Name - radGR : Text - (Grand Rapds)
Control Name - radKZ : Text - (Kamalamzoo)
Control Name - radTC : Text - (Traverse City)

I just want to get the text name to a string so I can put it in the database. Any ideas?