General information
Category:
Forms & Form designer
>I need to close and then reopen the table associated with a grid. In doing so I loose the grid's formatting. I can redo the format in code, including the RecordSource reference (unless there is a better way) but I also loose the code associated with a field's click event. How can I get my click event code back? My RecordSourceType is 1 - Alias.
>
>
Just out of curiosity, why would you need to close a table while in a form then re-open it? What about using a view?
For odd reasons, I've played with this before and what I did was create an empty cursor from the main grid table. It contains the correct structure but has no records. When you want to close the main table simply, reassign the grid recordsource to the empty cursor, close your table, re-open your table, then assign the recordsource back to the main table. I know it's strange but it worked for me...
Michael
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only