Hi, I'm trying to use the DataGrid object in a form in Access 2000 and I find this strange behavior. The grid currently resides in one of the tabs of my tab control and once I initialize and set its datasource to a resultset it works fine, I can edit and update the grid, but once I click on another tab and come back to the tab with the grid, the grid becomes locked (cannot edit) and the field that I click on loose its value...

Any suggestions?

Access's sub forms normally work a lot better than the data grid and are a lot easier to use.

Is there some reason you can not use a sub form?


Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com