Multi Select Radio Buttons for multi records (2000)

Topic

New Reply

I am creating a database of PDF files and need to also record where they have been distributed (there is a finite list of possible web sites etc.)

I have a table which lists the PDF files which is constantly added to and a second table which lists the possible distribution locations. Then I have a third table with two fields one to record the PDF File and the second to show a Location. But they can have more than one location.

The users want all the possible location options to be available on radio buttons rather than creating separate entries on a sub form.

If I create the requisite radio buttons how to I then get Access to create the necessary number of rows on the table?

I have inc a database called location with a couple of tables – a form with the sub form which was my preferred choice – and a just started radio button form where I am now stalled!!

Thanks

Reply | Quote

Replies

In attachment a quick and dirty sample of what you want.
I have change the record source of the form ‘PDF Destination Radio Button Form’ to the table ‘PDF Ref’
In the On Current event of the form, I do 5 DCount in the Destination Table to find out if the record for the PDFRef already exist and set the according option button to True or False.
In the After Update event of each option button I create a Insert or Delete sql string to update the Destination Table.

As comment, I should change the LocationRef table to add an autonumber as ID and use the ID’s in the Destination Table, like you have done for the PDF Ref’s.
HTH

Reply | Quote

Thank you very much for this. I did not know where to start for this one. I certainly was not expecting such a complete answer so quickly!! I agree with your comment on the location ref .

Cheers

Roberta

Reply | Quote

Thank you very much for this. I did not know where to start for this one. I certainly was not expecting such a complete answer so quickly!! I agree with your comment on the location ref .

Cheers

Roberta

Reply | Quote

In attachment a quick and dirty sample of what you want.
I have change the record source of the form ‘PDF Destination Radio Button Form’ to the table ‘PDF Ref’
In the On Current event of the form, I do 5 DCount in the Destination Table to find out if the record for the PDFRef already exist and set the according option button to True or False.
In the After Update event of each option button I create a Insert or Delete sql string to update the Destination Table.

As comment, I should change the LocationRef table to add an autonumber as ID and use the ID’s in the Destination Table, like you have done for the PDF Ref’s.
HTH

Reply | Quote