Continuous Form - Checkbox - Last Checked Box not updating table

[rdba]

First timer here - I did search the forums for this issue but did not find it in the top 20 or so posts.

So I have a continuous form that returns all of the files in a designated folder. I've written a procedure that takes all files that where the Checkbox = On and returns the necessary SQL code with no issues.

The one problem I am having is that unless the user clicks the form again after checking a checkbox, the last checkbox does not update the table.

Is there something I can do like OnClick which will force this update even if the user does not click off the checkbox?

Here you can see that the form has 3 fields checked and the table only shows 2.





Now once I click anywhere on the form that field will update in the table, but this is to restore our backups and I can't really trust someone to remember to click off the checkbox and risk losing the last file being restored.

Thoughts?

[pbaldy]

My first thought is that presuming you would have the user click a button to run your procedure, that would accomplish the goal of saving the record. There are ways of forcing the record to save, but I suspect you're worrying about something that won't actually be a problem in practice.

[rpeare]

I agree with pbaldy unless you're showing a subform with your table view it's not really an issue. You can force an update by using me.refresh in the on click event of the checkbox but really it shouldn't be an issue.