Writing Modifications from Bound Form

[WhizzkidWallace]

Hi...I have a question.

I have a form that lists some fields in a continuous form, one of the fields being called 'Include?' and of the yes/no type.

The user puts a tick on the records they want to use, then clicks a button in the footer of the form to do a certain ACTION on the records clicked with a YES....does that make sense.

The problem is, after putting the last 'yes' tick in place, they then click the ACTION button in the footer, BUT the record thay just clicked remains in edit mode, and has not been updated. It is therefore NOT included in the ACTION, even though the user has put a tick in its box?

I have the code for the ACTION_click event sorted, but need something to first make sure that any changes to the data are written first. I need the form to stay open though, because other unbound data on the form is used within the ACTION code.

Please let me know if that makes sense, or I will try to explain further. I bet its dead simple...

Thanks

 

[pdx_man]

Save the record first. You can have this on an event on the tick or on the button before any action takes place. Depending on the version you have, it is something like ...

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[WhizzkidWallace]

Excellent. Many thanks