Automatic Update on Option Group from a select query

[JYK]

Hello:

I was trying to find a way to automatically select an option in a
option group from a select query.
Not to confuse anybody, let me explain the scenario.

I am building a database which is basically a task organizer.
On the form "Status Update," user puts in a Planner name, Due date
existing in the master task list Table, and the corresponding task,
and want the option group with radio buttons to display the correct
status of the project. I have built a select query as well to return
the correct value of the radio button but don't know how to input that
number into the option group.

Is this possible?

Thanks!!

 

[KARL DEWEY]

The option group needs to be bound to the field.

 

[JYK]

Theoptiongroupneeds to be bound to the field.
--
KARL DEWEY
Build a little - Test a little









- Show quoted text -

Does that mean it cannot get information from a query source?
I guess the option would be combo box or list box?

 

[KARL DEWEY]

The option group is on a form. The form uses a query as source. The option
group frame is bound to the field of the query that get data from the table.