Check Boxes

[Hayley Baxter]

I have some check boxes on my form and on click I open a report to preview. When a report is closed the tick is still there which is fine but when I select another report then they are both ticked which I don't want

What I'm really looking for is for the tick in the previously selected check box to disappear when another check box is ticked.

Any tips on how to do this greatly appreciated

 

[adz2013]

Put this on the onclick event:
If Me.Checkbox1.Value Then Me.checkbox2.Value = False
You could probubly also use an option group.

HTH

 

[Rich]

It can be done but wouldn't it be better and require less code using option buttons

 

[Hayley Baxter]

I was trying to follow the example in the Northwind.mdb using the option buttons but everytime i tried to implement this in my db I just couldn't get it to work. I had the option group set, preview button, print and cancel copied over the code changing the field names/frmnames but no joy. Is there something obvious I'm missing or perhaps I've just forgot to change something.