General information
Category:
Forms & Form designer
>When using an SQL select to generate a temporary table to use as the recordsource for a grid display on a form, the initial display presents correctly. The columns and headers are individually formatted and color selected as well as the enabled properties are set per field from the temporary file.
>
>When reselecting the data and issuing the form.grid.recordsource to the temporary table generated, as in the initial code, the resulting grid looses all of the formating, color, and enabled properties.
>
>Any ideas as to how to correct this issue?
Before doing your SQL Select, set the grid rowsource to "", then set it back to the cursor name after.
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