Dino,
Yes Dino I did solve it, and it worked out very nicely. Unfortunately I can not give you the code but it was pretty easy to do. First, made a table which
stored all the properties that were modified in the grid when designing it. Make the table in a manner so that each grid property is stored in its own record. Then I made a class out of a grid and added a method to it. The method read the records from the table and formulated the grid property text strings for macro substitution.
For example:
text1 = [the name of the property stored in the table i.e. 'this.ControlSource'] + " = " + [the value stored in the table]
&text1
The above code is in a loop so all the records will get executed when the method is called. You also have to store the property value type i.e. char, numb, or logical so you can properly build text1. The method needs to know which records to read so I had a field called gridid in the table. I stored this value as a property of the grid. The table can also have userid in it too.
Now, when ever the record source changes for your grid simple call the method you created. Works great and you can even add new properties to the table at run time and call the method to get grid updated.
Hope this helps!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement