Results 1 to 2 of 2
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Filter combobox options

    I want to be able to filter a forms (frmUnassignDevices) combobox to only show devices that are associated with the employee that is selected on another form (frmMainMenu). I have it set now to where I can delete information associated to an employee but it shows every device in the database. Is there a way to have it limit only to those that have been assigned to that employee?

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    a combobox is fundamentally having a record source that is either a table or query; it its property look at the record source... press the 3 dot ellipses icon to open up that record source - where you can alter it to be a query with a criteria for the Employee ID.... the specifics of it of course depends on your data structure but this is the overall idea....

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

Similar Threads

  1. ComboBox options
    By dylcon in forum Forms
    Replies: 20
    Last Post: 06-07-2013, 09:26 AM
  2. Replies: 1
    Last Post: 09-06-2011, 01:47 PM
  3. Replies: 5
    Last Post: 07-23-2011, 11:48 PM
  4. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  5. Replies: 0
    Last Post: 12-16-2009, 01:14 PM

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