Name buttons in an option group from a table dynamically

[Geoff]

Hi

I have a form with a command button "Print Report" which when activated
displays an option group with a button individually named for each client
(the option group was created using the Option Group Wizard). These buttons,
when selected, print reports for each specific client.

My problem is that the records in the "Clients" table keep on changing, with
new clients being added and old ones removed from the table.

Is there a way to code the command button so that t will dynamically create
and name the option buttons in the option group based on distinct records
from the "Clients" field in the Access table and then, to size the option
group frame according to the number of buttons in the frame?

Thanks in advance for your help

 

[Klatuu]

Using the option group is not a very good way to do that. I recommend
replacing it with a combo box with a row source that will list all your
clients.

 

[Geoff]

OK thanks - I'll try that.

Using the option group is not a very good way to do that. I recommend
replacing it with a combo box with a row source that will list all your
clients.