Option Button Values

[Malinda]

I am trying to automate the values of the option button groups that I have on
a form by entering those values into an external table. I have tried using
macros to accomplish this, and my coding skills are very basic. Basically I
want the external table to only contain one record with several numeric
fields that will be updated daily. When the form opens that contains the
option button groups, I want their option value property to be automatically
pulled from that exteranal table. If anyone can steer me in the correct
direction, it would be a tremendous help.

 

[Duane Hookom]

What do you mean by external table?

 

[Malinda]

Sorry for the wording.....actually another access table is what I mean.

 

[Duane Hookom]

You can bind an option group to a field in your table.

 

[Malinda]

Definatly, I understand that option.....however, I have implemented a touch
screen program for the sake of eliminating most of the data entry
itself.....this was one of the trickier parts to get executed.....Basically I
want our data entry personnel to have very limited interaction with the mouse
or keyboard. Thus the reason I am trying to store values that will later pop
us as the default value of a field on any given form. Thanks again for your
help though.

 

[TC]

Say you have an option group with three options as shown below.

Caption OptionValue
property property
AAAA 11
BB 222
C 3333

Say you bind that group to a field in a table.

If the user clicks the BB option, that will store 222 in that field.
Later on, when he redisplays that form, the option group will see the
value 222 in the table, and will preselect the BB option in the group
control. In other words, you will see whatever option was selected last
time.

Does that help?

TC