option group to query or table

K

kris

Anyone know the code to associate and update from an option group check box
to a query check box?
Option Group: "frame116"
RUNNING "option121"
ON-HOLD "option122"
OFF-HOLD "option123"

Query "Status"
field: "RUNNING"
field: "ON-HOLD"
field: "OFF-HOLD"
 
J

John Vinson

Anyone know the code to associate and update from an option group check box
to a query check box?
Option Group: "frame116"
RUNNING "option121"
ON-HOLD "option122"
OFF-HOLD "option123"

Query "Status"
field: "RUNNING"
field: "ON-HOLD"
field: "OFF-HOLD"
Click to expand...

An Option Box (frame116) is a control with a single, numeric value. If
you're trying to update three fields, it is not the appropriate type
of control! Could you instead use a rectangle with three bound
checkboxes, one bound to each of these fields (which I presume are
True/False fields)? Or, if the three values are mutually exclusive,
consider changing your table design; have *one* field named Status,
Integer type, with 1 interpreted as Running, 2 as On-Hold, 3 as
Off-Hold. Bind the option group control to this field.

John W. Vinson[MVP]
 
K

kris

Hi John,
Yes I could do the bound check box thing. As a matter of fact I had that
done at one time. It's just the frame is so quick, ez and it looks good
giving the form an application look and feel. It's not that big of a deal
though. I was just wondering. Thank you very much for the reply.
 
Top