Hi,
Set rst1 = CurrentDb.OpenRecordset("Select WeightInKgPerBag, totalbags from tbl_grouping_Mar")
rst1.MoveFirst
...furter code works well if there are records available in the tbl.
When there is no record in the table, it produces Run-time error '3021' - No Current Record.
How can I come out of this?
Please help.
Thnx
Set rst1 = CurrentDb.OpenRecordset("Select WeightInKgPerBag, totalbags from tbl_grouping_Mar")
rst1.MoveFirst
...furter code works well if there are records available in the tbl.
When there is no record in the table, it produces Run-time error '3021' - No Current Record.
How can I come out of this?
Please help.
Thnx