Bug in requrying subform in ms access

hi,

When I click an add button on a form and new form loads, this form has a sub form. On this form's onload event VBA makes the form move to the add new record record. This part is OK. It then executes multipule SQL statements which insert data that are to appear in the sub form. The VBA in the main form then executes a requry on the subform. The subform is also set so that a field in it links to the one in the main form.

When the form loads I find that the data in the subform is appropriate for or would be appropriate if the main form displayed the first record rather than the add record.

I've also found that when this form is close and then re-opened then subform contains the appropriate data.

I've also found that after the main form loads if i click on a command button that executes a requry command on the subform then the sub form displays the appropriate data. I've also tried in the VBA code to execute a requry command using several different event (onload for instance) and none of them do anything.

Please help!