>I have a grid that's giving me trouble.(recordsource is cursor/controlsource is cursor's fields)
>
>Whenever I delete the first record from the grid and no other records exist in the grid, the line disappears but then when I INSERT a new record into the grid the row is blank-the grid doesn't show the record- but the record in the cursor exists. Only when I INSERT another record does the grid show the first record and the secord record, the first one was invisible(a calculation to a sum column gives me a correct value so I know the record is there but invisible).
>
>I refresh the grid after INSERTing a new record and I refresh after DELETEing the record. I only get this problem if the record is the first row in the grid. When other records exist, I have no problems INSERTing or DELETEing records in the grid.
>Can anyone assist?
>Any help would be appreciated.
>
>If it's not to much trouble I had another question...what's the code to have a combobox open automatically when it receives focus?
>Thanks, Jerry
Jerry, you'll have to reset the grid's recordsource in code after the cursor is emptied. Something about no data can make a grid forget what it's doing. You'll probably have to reset any special column properties as well...
Erik Moore
Clientelligence