Can anyone help me with this ? PLEASE!!


I have a form based on a query or table ( I have tried both) showing results in continuous form mode, each record has a checkbox to select it for inclusion in a further query, when all the required records are selected I click on a button and call a function to carry out further processing.

The problem is this. when I tab between records then the previous record is updated to the table, that is if I click on the checkbox the check box in the table is checked, however when I have selected the last record and click on the proceed button the last record is not updated. WHY ?


I am sure I am missing something very simple here but 3hrs down the road and i'm still no further on.
Thanking you in advance

Pete

Hi Pete,
Try adding a me.requery as the first line on your button. This causes the form to be updated before going on to select the records

Marion

Thanks Marion.

that worked. Its easy when you know how.

Pete