Re: Combo Box Filter

I'd be inclined to add a combo box to the Form Header section of the combo
box that would allow you to select an account number. Then, add a WHERE
clause to the subform's RecordSource query that filters the recordset by
that combo box:

WHERE AccountNumberField = Forms!SubformName!ComboNameOnSubform OR
Forms!SubformName!ComboNameOnSubform Is Null


Then put a requery action on the AfterUpdate event of the subform's combo
box to always requery the subform after you make a selection.
--

Ken Snell
<MS ACCESS MVP>




"Stacey" <Stacey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D8600CF9-F5AE-47FF-A781-C30FC17BD2DB@xxxxxxxxxxxxxxxx
Yes Ken, that takes care of part one (form to suform filter) however part
two
is where I am really having the problem with.....each employee has about
10
accounts I would like to filter through each account using a combo box in
the
subform. kind of like this.
step 1. locate employeeid
step 2. locate account within employeeid
As you scroll through each account within each employee id, all records
accociated with each account should change in accordance to which account
you
are looking at within the employeeid. Any ideas? Thanks!


"Ken Snell (MVP)" wrote:

Put cboemployid in the LinkMasterFields property of the subform control
(the
control that holds the subform object), and put in the LinkChildFields
property the name of the field that holds the employeeid value in the
subform's RecordSource query. That will link the subform's records to the
value selected in the combo box.

--

Ken Snell
<MS ACCESS MVP>


"Stacey" <Stacey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9D3CA438-DE77-460E-8F7E-EFEA50698053@xxxxxxxxxxxxxxxx
Has anyone ever done this? I have a combo box cboemployid in a form
called
employedit; when you select an item in the combo box it should filter
all
records associated with cboemployid by account in in a subform called
subform1.....now where I get stuck is, I would like to filter through
all
the
records in subform1 with another combo box cboaccounts, so that I can
see
all
records associated by account? Any help is greatly appreciated.





.

Relevant Pages

  • RE: How to link user accounts to external system?
    ... The employeeID attribute in AD is not copied when duplicating a user, ... I have created a web site used for account creation that prefills the ... HR database to fill in the employeeID field. ... > employee ID and something from AD like the user object GUID. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Combo Box Filter
    ... The WHERE clause that I posted would be added to the query that is the ... would have a Row Source query that returns the Account Numbers. ... box to always requery the subform after you make a selection. ... locate account within employeeid ...
    (microsoft.public.access.formscoding)
  • Re: OT. Stupid Developer Tricks
    ... Back in the late 80s I was messing around with the system and this guy mentioned it'd be great if I could write a program that would take money out of a bank and transfer it to his account. ... I had a form with, amoung others, two fields; Status and EmployeeID. ...
    (comp.databases.ms-access)
  • RE: How to link user accounts to external system?
    ... As far as I know there is no way to fire an event when an account is created ... Check the employeeID value, if empty report, if populated do a search ... when duplicating the user. ... >> HR database to fill in the employeeID field. ...
    (microsoft.public.windows.server.active_directory)
  • RE: How to link user accounts to external system?
    ... computers mmc to copy and that the employeeID attribute is being copied. ... authorization in apps and automated user account provisioning is not yet ... > HR database to fill in the employeeID field. ... > move the user object to the correct OU in your orginization. ...
    (microsoft.public.windows.server.active_directory)