Refresh a Grid

[dvannoy]

I am using a datagrid to view records with a certain status. On my form a have a "Refresh Grid" button that I want to grb new records into the grid.
My problem is, that if there are no records to be pulled into the grid, I get an error because the grids datasource cannot be set causing mt SQL statement to fail. how can I get around this?
I tryed saying

if rsGrid.Recordcount = "0" then
msgbox"blaaa"
exit sub
end if

but that doesnt work since my sql statement is the first thing that gets fired off.


any help would be appreciated

Thanks

 

[RalphBrown]

Looks like an error trap would be your best solution.

Hope this helps,
Ralph

 

[phinoppix]

Well, error-trapping in this case should be your last resort. Maybe there are conflicts within. It will be helpful if you could just post the procedure that raised the error.