clearing tic boxes?

[A|ex]

How do i reset tick boxes on forms when you go to the next record?

Also in VBA whats the code to checking if a tic box has been ticked or not? can i use the

If tickbox is Null ? Or do i use tickbox = true (or false?)

 

[WayneRyan]

Alex,

Are the CheckBoxes bound?

If not, use the OnCurrent event of the form, to:

Me.MyCheckBox = False

If they're bound, don't reset them.

Wayne

 

[A|ex]

what do you mean bound?

all ive got atm are tick boxes on a form. Depending on which tick box they check i want it to take a value from a textfield and copy it to another.

Whats the code to clear a tickbox and set it to empty?

Also how do i group together say 6 tick boxes so only 1 of them can be ticked at any one time?

 

[WayneRyan]

Alex,

You need an Option Group. The single-value can be mapped (bound) to
a table if you want to.

Wayne

 

[A|ex]

i forgot about the option group! cheers m8 it worked fine