Results 1 to 2 of 2
  1. #1
    KWarzala is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    35

    Restrict Combo Box Options

    I have a Camera Check Out Log with the following fields:

    -Employee
    -Camera # (which is a combo box referencing a table that has the camera
    numbers)
    -Checked Out (yes/no)
    -Checked In (yes/no)

    I am trying to make it so that if for a certain camera #, if the Checked Out box is true, and the Checked In box is false, then a message box pops up saying that the camera is already checked out, or not even let them be an option in the drop down. I have tried a few different things, but can't seem to figure out how to separate the Camera # field from the data in that field, and wind up locking out the whole field. Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Instead of the row source of the combo being the table, make it a query:

    SELECT...
    FROM TableName
    WHERE CheckedOut = True AND CheckedIn = False

    Personally, I wouldn't have two fields. A single True/False field would tell you the camera's status, presuming you unchecked the CheckedOut box when a camera came back in. Or, since those are in the log table, I'd have date/time fields so I knew when each action occurred.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Don't show lookup list options in report
    By dara in forum Reports
    Replies: 1
    Last Post: 02-17-2010, 10:26 PM
  2. Toggle Button Options
    By Matthieu in forum Forms
    Replies: 2
    Last Post: 11-23-2009, 04:05 PM
  3. Format options in combined Form field
    By perry in forum Forms
    Replies: 0
    Last Post: 03-06-2009, 04:53 AM
  4. Restrict form access to certain people
    By DannyBoy7783 in forum Forms
    Replies: 2
    Last Post: 06-09-2008, 06:18 AM
  5. Bypassing Startup options with Ctrl W
    By rayc in forum Security
    Replies: 0
    Last Post: 09-06-2006, 09:18 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums