Option Group Question

[Guest]

I have a field in a form that is based on a lookup field in a table. I need
to add another option to the option group. I added the option to the field in
the table. How to I add the new option to the option group. Would I have to
delete the option group and start a new one?

I am using Access 2003. Thanks in advance for your help.

Best regards,

 

[Guest]

It is not necessary to delete the option group and start over. Just add
another button or whatever type of control you are using to the option group
and give it the option value you want it to return.

Now, you are using probably the worst misfeature of Access there is. That
is the Lookup field. I would suggest to get rid of it and create a table
that carries the text value and relate it to your data table.