Dynamic Option Group - Is it Possible?

I'm working on an unbound form in which enduser requirements state it is
necessary to see complete address information on the form. Ideally, i would
like to auto generate the radio controls via VBA. In a web world... this
would be cake.. but this application has to be 100% access.

Any help is appreciated - thanks.

Robbie Baquiran wrote:
I'm working on an unbound form in which enduser requirements state it
is necessary to see complete address information on the form.
Ideally, i would like to auto generate the radio controls via VBA.
In a web world... this would be cake.. but this application has to be
100% access.

Any help is appreciated - thanks.

First explain what "complete address information" has to do with radio
buttons and why you would need to "auto generate" them.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

By "complete address information" I am refering to their template:

Address Title
Address 1
Address 2
City, State Zipcode

I would like to autogenerate because the address will be queried based on
the selected client. Some clients have only 1 address, others have up to or
more than 5. One of the address will be selected and additional data be
supplied on the rest of the form.

Combo / list box will accomplish only half of this - since the formatting is
wrong - end users will reject it.
So my theory is to have a frame ... query for client address via DAO ...
loop and add radio controls containing the address id and changing it's
associated label to show address formatted as specified.

^^v

"Rick Brandt" wrote in message
. ..
Robbie Baquiran wrote:
I'm working on an unbound form in which enduser requirements state it
is necessary to see complete address information on the form.
Ideally, i would like to auto generate the radio controls via VBA.
In a web world... this would be cake.. but this application has to be
100% access.

Any help is appreciated - thanks.

First explain what "complete address information" has to do with radio
buttons and why you would need to "auto generate" them.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Why not just display the address in a continues form, and have a bound check
box to select which one?

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal