I have a drop down on a form that has different field
names that a person can export some data by. For example,
if they would like to export by Country, they would select
country and the data would be exported to excel by all the
unique countries in the database. I am trying to cut my
code size down and would like to do the following (if
possible)
code = "rst![" & ExportByValue & "]"
(Country Name)
instead of code = rst![Country]
What happens though is it looks at the above as a string
instead of getting the actual country field value.
I know in Excel you can do the following to build a
controls name: OLEObjects("OptionButton" & number).Object
Is there anything similar in Access???
Concatenating field name