fiogf49gjkf0d 1. NEVER use :Bindid in your SQL for a datagrid. EVER.
2. Never use the Bindid property of a datagrid. EVER. Use another databound control tied to the ID of the base table to raise your AXFormChange event handler.
3. Always script this stuff, handle your own SQL code for the grid.
4. Never do a
gridname.sql.text = "adfadfadsdfa.....
gridname.refresh
Yes that's TWO refreshes of the grid. (plus (1) and (2) for a total of FOUR queries of the Server)
5. Never do a
myRS.Open "adfadfasdfadf
set gridname.recordset = myRS
gridgname.refresh (plus (1) and (2) for a total of FOUR queries of the Server)
Yes that's TWO refreshes of the grid.
Fun time with grids.....
|