Update last record

[Garswood]

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

 

[MarionD]

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

 

[Garswood]

Thanks Marion.

that worked. Its easy when you know how.

Pete