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
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