I have a form with several data controls to produce combo boxes that have lists from various tables to facilitate data input. I'd like to try and shorten some of the code for queries. I've got a select case statement started, but what I'd like to do is something like:
datVariable = Data1
RecCount(Index) = datVariable.Recordset.Recordcount
(where Index is from a control array)
I don't recall the exact code at the moment, but I think you get the idea.
How can I make the data control a variable? I've tried using string and variant but with no success.
Help would be greatly appreciated.
-- Stacey --