Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box (Access 97)

    Hi

    I have a form with a number of combo boxes. When adding a new record, data entry for one of these combo boxes is optional (ie it can be left blank). However, I can not save the record as the form states I can not leave the combo box blank. Do I have to handle this by overriding the error message, or is there some simple command that does this and I am just having a slow day at the office.

    Thanks & Regards
    WTH

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Portland, Maine, USA
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (Access 97)

    Is the field in the table that the combo references set to required? If set to yes change it to no.

    HTH
    Don

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (Access 97)

    Hi

    Thanks for the reply. I already tried this and it did not work.

    Regards
    WTH

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Combo Box (Access 97)

    It must be either the table requirements, a table validation rule, or the validation rule for the combo box - those are the only reasons for Access giving you that message.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box (Access 97)

    Hi

    Like I said, yesterday was a slow day at the office. The problem was the table relationship in both the form and table making it mandatory to enter data. Once these were deleted, it worked fine.

    Thanks for the advice as it made me recheck things again.

    Regards
    WTH

Posting Permissions

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