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

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

HTH

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

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.

When you use unbound controls on a continuous form, ALL visible instances of the unbound control take on the value of the control associated with the current record. A2K may have a way around this with conditional formatting but I haven't used it so I can't tell you if this is the solution. Check out the property and see if it does what you want.