Dynamic Option Group - Is it Possible?

R

Robbie Baquiran

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.
 
R

Robbie Baquiran

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
 
A

Albert D.Kallal

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