Thanks
i set the controlsource of the text1 field but it should have been set on the column1, column2... fields one level up. custom classes take all the hard work out of it :)
~M
>>hi all,
>>I have a grid in which i am trying to show a few fields, i have to hard ode these columns in rather than use our own classes. I have reduced the column count down to 2, in the first i have a primary key field and in the second i have a date, both of these are set in the control source property of the text1 field under the grid. but when i run up the program the field in the second column is the second column in the table and not the field that i want, what i am missing here?
>>~M
>
>Hi Mark,
>
>Are they also the columns controlsource? Are you changing the table after the load of the form?
>
>HTH
>Beth
Go raibh maith agat
~M