I've a grid on a form, the record source is a table. I want to add to this table when the form first loads, the criteria for what to add is complicated and beyond the scope of SQL. I've create a method to zap the table then add to it what's needed. I've placed

THISFORM.REFRESHGRID() && RUN MY METHOD FOR ADDING TO THE TABLE

into the init method of the grid, but i'm sure this is the best place for it?

Somehow the table is being open twice?

Can anyone see anything wrong with what i'm doing?

Any help extremely appreciated