Dynamic Option Group - Is it Possible?

  • Thread starter Thread starter Robbie Baquiran
  • Start date Start date
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.
 
Robbie said:
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.
Click to expand...

First explain what "complete address information" has to do with radio
buttons and why you would need to "auto generate" them.
 
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
 
Why not just display the address in a continues form, and have a bound check
box to select which one?
 
Back
Top