Multiple Combo Box Filter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cameron (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 08:07:29 -0800

I am wondering if it is possible to create a form which
contains a subform that displays various pieces of
information regarding the employees of a company, and
have a series of combo boxes on the main form which
controls the entries that it displays. However, I would
like it so that if the combo boxes are blank all employee
entries are displayed but they can be limited by using
the combo boxes in any combination. I am also not sure
if this requires the use of filters or something else
altogether.

Cameron

Relevant Pages

  • Re: Referencing multiple people in one table? (Table structure set-up)
    ... create one subform for assigning all employees, ... subform, with multiple combo boxes for Employee ID and Role ID, but when I ... the records for other employees (for instance if I've assigned project ...
    (microsoft.public.access.tablesdbdesign)
  • RE: New to Access
    ... In design view I can see my subform but in form view ... your case you have entity types Employees and Jobs to start with, ... another table, Assignments say, with columns EmployeeID and JobID. ...
    (microsoft.public.access.gettingstarted)
  • RE: New to Access
    ... In design view I can see my subform but in form view ... your case you have entity types Employees and Jobs to start with, ... another table, Assignments say, with columns EmployeeID and JobID. ...
    (microsoft.public.access.gettingstarted)
  • Re: dynamic combo box on subform- show full list Box on main form
    ... babs wrote: ... the combobox on subform is on the afterupdate event of the subform ... You will need an analogous line to also requery the main ... queries that only show employees Not sched(ie. ...
    (microsoft.public.access.formscoding)
  • Re: Selecting items from the list of a combo-box.
    ... The subform is just a ... * Get the recordset of Employees ...
    (microsoft.public.access.formscoding)