Clearing Checkbox After Report

[buckwheat]

I have a form with several checkboxes and a cbo box.

A name is selected from the cbo and a checkbox selected for a specific report. The checkboxes are named and associated with a macro to trigger the report.



Can anyone tell me please how to clear the cbo and checkbox once the report has opened and then is closed, so a new selection can be made?

Regards
Buck

[rzw0wr]

Me.Requery should reset the combo box.

How are the check boxes named?

Dale

[buckwheat]

Thanks Dale for the cbo solution.

checkboxes are named for ease of identify when troubleshooting, some e.g., NoFinChosen; NoFinBWCChosen; FinChosen; FinBWCChosen, etc.

[buckwheat]

Dale,

I understand the requery will work best on the form's "on open event." But in this case, when users select the preview or print button for the report, the report opens or prints, once the report is closed, Users will still have visibility to the form to make another selection, this is when I need the check boxes and cbo to be clear, OR maybe I'm just putting the "requery" command in the wrong event.

[rzw0wr]

You can try;
Put this with the requery command.

if NoFinChosen = true the NoFinChosen = false
Do this for each check box.

Note; If you keep the IF function on 1 line you don't need an End If.

Dale

[buckwheat]

Thanks Dale. I may bypass this process and have the users clear them out themselves, since there are 24 check boxes. But if I decide to use this process, what event would it be please?

[rzw0wr]

I would us the Print command button.
After everything is printed, just before you leave the sub.

I am looking for code I wrote to clear check boxes a little while ago.
If I find it I will post it for you.

Dale

[buckwheat]

Dale,

I decided to enter each name as you suggested in the previous thread and it worked perfectly. . . Thanks so much.

I would us the Print command button.
After everything is printed, just before you leave the sub.

I am looking for code I wrote to clear check boxes a little while ago.
If I find it I will post it for you.

Dale

[rzw0wr]

Buckwheat,

Dim ctl As Control

For Each ctl In Me.Controls
    If ctl.ControlType = acCheckBox Then
        ctl = False
    End If
Next ctl

This is the bare bones code.

The only thing you need to do is make a command button, Give it a name like cmdReset and copy this into it.


Dale

[buckwheat]

Hi Dale,

Thanks, I've already entered the code from your first suggestion, so I'll keep this one for future reference. Thanks again. I've also added another thread for help advancing to a new record, if you're available to help please.

[rzw0wr]

Buckwheat, You have one of the best here helping you now.
All I would do is confuse the situation.

Dale

[buckwheat]

ok, thanks