I have a table that has 130 fields (attributes to each specific item) the user wants to be able to select the fields that they need to see at any specific time. to enable this I have a form linked to a table that contains all the attributes and control names (not visible to user) and a y/n field. I have a viewer form that has all the controls on it (displayed as a grid view). when the user opens the viewer form, I want to loop through the list of items they want to see and the list of controls and only show controls they want to see.
trying to do something like this on the form load event (assume all controls start as not visible and rst is a recordset of the control names they do want to see)
dim ctl as control
for each ctl in me.controls
rst.movefirst
do until rst.eof
if clt.name = rst.name then ctl.visable = true
rst.movenext
loop
I cant get to the .visible property for the controls
any help is GREATLY appreciated