I want to add four buttons to a subform and only allow one choice

D

debbiecatal

I am designing an access database to record statistical data on counselling
sessions to be used by novice users. I want them to enter data in a form
which has a subform for attendance. The drop down list is not working in the
subform and I can't find out why, so I added 4 yes/no buttons. I would like
to set these buttons so that only one is selected but I don't know how. Can
you help? Or can you tell me why a drop down list box might not work in a
subform?

Thanks

Debbie
 
C

Carl Rapson

You can use an Option Group control to ensure that only one button is
selected. Just specify toggle buttons instead of check boxes or radio
buttons. Keep in mind, in a subform each control will need to be bound to a
data field or the selection will show up on every record in the subform.
That means the Option Group control will need to be bound to a field in your
underlying table or query.

As to why the drop-down list doesn't work, you'll need to be more specific
as to what problem you're having. What is it doing?

Carl Rapson
 
Top