check box wont uncheck

[sandeep0000]

im using access 2003

when i check a box on the form and click to the next form, the box wont uncheck, am i missing something.
once a person completes a form and goes to the next i would like all the check boxs unchecked

i tried looking in the search couldnt find anything. sorry if there is

 

[sandeep0000]

i can uncheck it on the next form, but i would like the defaults to be unchecked

 

[prover]

in the onclick event you could:

me.checkbox.value = 0

if there are a bunch you could loop through comparing control types. suedo code:

if control = "checkbox" then control.value = 0

something like that.

 

[missinglinq]

I suspect your terms are muddled, as what you've posted so far doesn't make a lot of sense, as written.

when i check a box on the form and click to the next form, the box wont uncheck, am i missing something.

Do you mean to say when you click to move to the next record? Or are you clicking on a button to open up a second form?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[sandeep0000]

when i click and move to the next record.

when i close the form and re-open the checks that i did go away.

but i want it so when they click the next record that the checks go away and they can do the next person

 

[sandeep0000]

would it be like this in the code builder?

Private Sub chkH1_H2_Click()
If Control = "checkbox" Then Control.Value = 0
End Sub

 

[sandeep0000]

im kinda new to form making sorry
i did do some codes in build event -code builder

is this where i would do this code also?

 

[sandeep0000]

for each checkbox i have a code in the code builder

Private Sub chkSfm_3months_AfterUpdate()
If chkSfm_3months = True Then

Me.Sfm_3months = -1
Else
Me.Sfm_3months = 0
End If
End Sub

and so on for each one

 

[PHV]

My guess is that your CheckBox control should be bound to a boolean (YesNo) field.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

can u help me do this, im new to forms and having some problems with checks showing up on the next record

 

[PHV]

when they click the next record that the checks go away
In the Current event procedure of the form:
Me!chkSfm_3months = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

im sorry, about this


would it be like this?


Private Sub chkAided_AfterUpdate()
If chkAided = True Then

Me.Aided = -1
Else
Me.Aided = 0
End If
Me!chkAided = False

End Sub

if i do that i cant even click on it

 

[PHV]

What are chkAided and Aided ?
Did you understand my previous post (21 May 07 13:36) ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

no i dont sorry
i have about 10 yes/no fields


example of one is

Private Sub chkSfm_3months_AfterUpdate()
If chkSfm_3months = True Then

Me.Sfm_3months = -1
Else
Me.Sfm_3months = 0
End If
End Sub



where do i put Me!chkSfm_3months = False

 

[PHV]

Again, what are chkSfm_3months and Sfm_3months ?
Which controls are bound to fields and which (if any) aren't ?
Please read carefully either FAQ in my signature.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

sfm_3months is the orignal field that im hiding

chksfm_3months is the field that is visable and can be clicked on

 

[PHV]

sfm_3months is the orignal field that im hiding
Private Sub chkSfm_3months_AfterUpdate()
Me!Sfm_3months.Visible = (Me!chkSfm_3months = True)
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sandeep0000]

i dont know what im doing wrong,
i put this in my code builder

sfm_3months is the orignal field that im hiding
Private Sub chkSfm_3months_AfterUpdate()
Me!Sfm_3months.Visible = (Me!chkSfm_3months = True)
End Sub

but when i click on the next record the check is still there

 

[PHV]

Reread my post stamped 21 May 07 13:36