Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Forms & Form designer
Hi Anders
Set Grid.ColumnCount first, then set ColumnX.ControlSource.
>Hi,
>I've never worked with grids before and therfore probably this question is very basic, but however, I cannot get it work as I want it to work. My problem is that I want to populate the grid cells with data from myTable. This I can do by setting the Grid RecordSource to myTable and the RecordSourceType to Table. The problem is that I do not want the data to populate the columns in the same order as they are defined in myTable. I have tried to set the Columns CotrolSource to the field I want, for example myTable.field3 for Column1.ControlSource and so forth, but the result is that all rows show the same value, i.e. the first record in myTable. The field order is however in the right order as I have specified. What do I do to solve this problem?
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