Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    Sydney, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dynamically Create Option Buttons (Access 97)

    Hi

    I would like to dynamically build option buttons in a frame on a form. I would like to do this based on an 'Activate' field in a data table being set to either 0 or 1. Table looks like this:

    TypeID Description Activate
    1 Cover page 0
    2 Document 1
    3 Table of contents 0
    4 Heading 1
    5 Text 1
    6 Table 1
    7 Graph 1
    8 Image 0

    Has anyone some simple code for doing this? Sorry, my Access skills are a little rusty and I need to do this quickly.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dynamically Create Option Buttons (Access 97)

    Can you explain a bit more? In an option group, only one button can be "on" at any time.

    Would you like to create an option group consisting only of the items in the table whose Activate value is 1 (in your example, items 1, 4, 5, 6 and 7)? Or something else (and if so, what)?

Posting Permissions

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