Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disabled check box on form

    Access 97 on Win98se

    I have a switchboard that is preloaded with report options. I'm trying to add a checkbox to the form that will be used to indicate whether the report should be printed or previewed. The checkbox is unbound. For some strange reason when I go to click on the check box nothing happens. It's default setting appears and its properties say that it is enabled and not locked. Why is this happening? Thanks in advance.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disabled check box on form

    The check box must be bound to an underlying field in order to be usable. Create a field in the table that supports the data type such as a YES/NO field and it should have that field as a data source.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disabled check box on form

    Me again!

    You'll probably want to consider putting some code or a macro behind the click event of the button and perhaps even consider using a command button to bring up the report in preview mode or printing.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disabled check box on form

    Thanks for your responses. I've decided to use a msgbox with yes/no/cancel buttons instead to achieve my objective.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disabled check box on form

    No, a checkbox doesn't need to be bound to a field to be useful. If you want the value of the checkbox remembered from session to session then you'll likely want it bound to a field somewhere. However, if you are just using it to indicate an option for your current session (e.g. whether to preview or print a report) it doesn't need to be bound. Just retrieve its value (True/False) in the code for your form (e.g. in the code behind the button that either prints or previews).

Posting Permissions

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