Re: Combo Box Filter

Ken, are you saying that I should put that code in the row source field?

"Ken Snell (MVP)" wrote:

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: Combo Box Filter
    ... "Ken Snell (MVP)" wrote: ... would have a Row Source query that returns the Account Numbers. ... locate account within employeeid ...
    (microsoft.public.access.formscoding)
  • Re: Turning off import errors
    ... Within access you can get the dbase to compact on close by using the action ... "Ken Snell (MVP)" wrote: ... account balances at month end through a time series of many months. ...
    (microsoft.public.access.externaldata)
  • 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: 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: No updates for Stinger
    ... MowGreen [MVP] wrote: ... > You cannot use it unless you Create an account and it wants your ... > Why Start getting Spam,, After 10 years on the internet and No Spamm ... so on) and some of the trials have, in fact, required a valid email ...
    (microsoft.public.windowsxp.newusers)
Loading