Deselect check box on form closing

[barit]

Is it possible to automatically have a selected check box revert to an unchecked state when the form is closed. If so how would you do this?

Any suggestions would be appreciated

 

[KenReay]

Hi

How about in the Form Unload event:

MyCheckBox = False

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[barit]

Thanks for the suggestion. However it only deselects check box for the first record on the form.

On this form users restrict records by using a multiselect list box. A command button is used to list out all names selected from the list box so that the names selected can be edited and the end user can identify if they want this person on a specific list. If they do they click on another command button that will allow the user to compelte further data entry.

IU want to be able to deselect the check box so that each time the user enters for one, they have a clean slate of records to work from.

Any other suggestions would be most appreciated.

 

[KenReay]

Hi

In that case

Again in onload event

docmd.setwarnings false
docmd.runSQL "UPDATE MyTable SET MyCheckBox = False;"
DoCmd.SetWarnings True

Or if you have a multi user situation a slight variation on same, user (say) UserId to limit criteria

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[barit]

Thank you so much. It works like a gem