>I have a form with a grid that has a varying number of columns based on user input. I want to Validate user entry, add the value entered by the user to the total in the last column and have some kind of an on key command to do something else with the user entered number.
>
>I created the form with the grid on it, without and column count or recordsource. When the user gives the form enough information, I set the grid up with the necessary number of columns and attach it to a record source. Then I go thru and assign controlsource for each column. That all works just right. But I can't figure out how to, or where to put event code when I don't have the columns at design time.
>
>Thanks for any assistance you may provide.
>Pamela
You could write a column object with code and add in all the code for methods and events and then use add object to attach the column to the grid
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers