On the form load event give the option button you want selected a value
of 1

Joe Conaty
Nations Direct IS Dept
(xxx) xxx-xxxx  Ext 221


-----Original Message-----
From: Charles Jayawardena [mailto:charlesds3@y...]
Sent: Monday, April 29, 2002 7:58 AM
To: professional vb
Subject: [pro_vb] Working with option buttons in Access..........


Hi All,

I need help on Access option button handling.

That is please send me some samples on how to work with access option
buttons. I have two option buttons in a form that I call through another

form. But at the moment both option buttons are selected when the form
is
displayed first time. What I need to do is to have only one button
selected by default when the form is displayed. Also when one button is
checked by the user the other should be unchecked.

As you'll would have guessed I'm a beginner to Access.

Thanks a lot.

Sudharshan.