Yes/No Check Box 1

[ghost807]

I have a Check Box that i need to reset each time a form is loaded. the check box is part of the database.
what i'm trying to do is when the user selects the check box on one form and clicks the ok button it will open another form.
this form will show the selected records in conditional formating. (the form is set up like a map so that the item can be found quickly)
everything works great except the check box stays checked until the user unchecks it.
Is there a way to set all the checkboxes in the table to No when the form opens?
Thanx for any help you can provide me.

 

[MakeItSo]

Yepp.

Add this to the Load() event of your form:

Sub Form_Load()
Me!YourCheckBox=0
End Sub

That's about it! ;-)

MakeItSo



Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[ghost807]

This only seems to work for the current record. not the entire RecordSet.
I think i will try to do a loop but any more suggestions would be really helpfull

 

[MakeItSo]

Try this for the loop:
Dim rs as Recordset

Set rs=Me.RecordsetClone

Do While not rs.EOF
rs!YourCheckBoxField=0
rs.MoveNext
loop

rs.Close

However you could also create a small Update Query:

DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE YourTable SET YourField=0"
DoCmd.SetWarnings True

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[ghost807]

This works great. thanx for the help. i ended up using the second method.
just one more quick question.
is there a way to refresh the form after the SQL code has run?

 

[ghost807]

BTW i like your web site.
Interresting stuff.

 

[TonyJollans]

Hi ghost807,

It is probably easier just to update the table in a single go before you start, with something like ..

DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE [TableName] SET [CheckBoxName] = No"
DoCmd.SetWarnings True

Enjoy,
Tony

 

[TonyJollans]

I should have read more carefully. Andreas has already posted the same thing

Enjoy,
Tony

 

[ghost807]

Thanx guys. i had to move where i was doing the SQL code. i ended up placing it in the same event that i use to open the form just running that first.

But once again thank you for the help.