Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi Select Radio Buttons for multi records (2000)

    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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Select Radio Buttons for multi records (2000)

    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
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi Select Radio Buttons for multi records (2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •