Dynamic Option Group - Is it Possible?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robbie Baquiran - 23 Sep 2005 21:32 GMT

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.

Reply to this Message

Rick Brandt - 23 Sep 2005 22:08 GMT

> I'm working on an unbound form in which enduser requirements state it
> is necessary to see complete address information on the form.
[quoted text clipped - 3 lines]
>
> 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.

Signature

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

Reply to this Message

Robbie Baquiran - 23 Sep 2005 22:58 GMT

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

>> I'm working on an unbound form in which enduser requirements state it
>> is necessary to see complete address information on the form.
[quoted text clipped - 6 lines]
> First explain what "complete address information" has to do with radio
> buttons and why you would need to "auto generate" them.

Reply to this Message

Albert D.Kallal - 24 Sep 2005 07:21 GMT

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

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to this Message