Option Group not recognising Bound field

G

Graham

I have created an option group using the wizard - there are 2 option buttons
and it is bound to a field ContactType.

There have not been any changes to the option group since its creation with
the wizard.

When the form is opened both buttons are greyed out and if one clicked there
is a message at the bottom of the screen
Control can't be edited: it's bound to unknown field 'ContactType'.

I've tried relinking the table.

Access 2003
 
D

Duane Hookom

Does your form record source contain the field "ContactType"? Is the form's
record source updateable?
 
G

Graham

Hi Duane

So embarassing.

I had assumed that I had based the form on a table, but when I investigated
it is an SQL statement.

When will I learn not to assume?

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option Groups: Can I Group the Buttons AND the Box They're In? 2
Option Groups 5
Option group item selection by keystroke 3
Option group in a form 2
Option control group unbound 5
Bound control doesn't update table 2
Option Group - Clear Yes/No 8
Combo box assigned to a field not working 1

Top