Option group doesn't wok

[johnw]

I'm using Access 2000.
I guess this is a dumb question but I'm new to designing in Access.
I've added an option group onto a new form.
I placed the option frame first then put three option radio buttons on
it.

When I click any radio button it works OK but as I change from record
to record the same option buttons remain selected on ALL records.

They don't seem to give me options that differ for each record.
What am I doing wrong?
Many thanks for any help
John

 

[Larry Linson]

Did you specify a ControlSource for the Option Group? Right-click on the
frame, choose Properties, click the Data tab... and set it to the Field in
the RecordSource into which you want the value to be stored.

Larry Linson
Microsoft Access MVP

 

[johnw]

Thank you Larry.
The key word was frame!
I'd been trying to select a ControlSource for the options but had been
clicking on the Option Control itself - instead of the frame around
them.
Hence there was no ControlSource available.
Many thanks
John