Re: Combo Box as Filter???

Tech-Archive recommends: Fix windows errors by optimizing your registry

If you need a value like this to be available to the entire application, you
could use a Global variable; however, as Rick points out, home grow security
doesn't really work.

"Beatrix J B" wrote:

I plan to make a log on form which opens upon opening application put some
input box for user log on with password and user nomber and a combobox that
looks up to department tbl.

Based from the input in the log on screen ..... this would serve as a basis
for the filter.

Just would have to research how to make a log on screen and pass the values
placed in it ... just starting to program. :-)


"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:77CFD6F3-7143-42B3-8945-F46C3C109A68@xxxxxxxxxxxxxxxx
It would be the same. You just need to use a query as the row source for
the
combo filtered on the user name. The question is, where are you carrying
the
user name?

"Beatrix J B" wrote:

Thanks klatuu ... this may sound silly but what i am asking for also is
if i
have a combobox... i want the contents of the first combobox be filtered
based from the current user... .. umm not good at explaining technically
..

I am currently doing a user .. cabinet .. drawer ... files project.

Thinking of making a form wherein it would be based from users tblUSERS
connected to other table using USERNO .... what i want is when i open the
form ... the 1st combo box (based on cabinets) would only display
cabinets
owned by current user .... I can filter the 2nd and 3rd combo box but i
don't know how to filter the 1st combo box.

Appreciate more help.




"Klatuu" <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B7419ED-F57B-40F5-9648-1B95B36AA657@xxxxxxxxxxxxxxxx
If this is not the most asked and answered question in this news group,
it
is
surely # 2.
What you are wanting is commonly called "Cascading Combos"
Without going into details (you can do some searching on this site and
find
many), the concept is to use queries for your combo rowsources that can
be
filtered based on the content of the previous combo. Combo 3 filters
based
on the value in Comb 2, Combo 2 filters based on the content in Combo
1.
When you make a selection in 1, requery 2 and 3. When you select from
2,
requery 3.

That's all there is to it.

"Bob Betts" wrote:

I have a form with tblUSERS as main table connected to tblCABINET
which
is
connected to tblDRAWERS and lastly connected to tblFILES ...


Created two combo boxes one that looks up to tblCABINETS table and
another
combo box that refers to tblDRAWERS ... both displays complete list of
cabinet and drawers regardless of who the user is displayed ...

What I want is that upon opening the form ... it would only display
the
userno and user name ..... with the combobox for drawers lshowing anly
drawers for that current user and after clicking the combox ... the
combobox
for drawer would be filtered based from the cabintes cbo box ... which
then
displays certain files based from the drawers filtered ...


Thanks.









.

Relevant Pages

  • Re: Combo Box as Filter???
    ... have a combobox... ... I can filter the 2nd and 3rd combo box but i ... cabinet and drawers regardless of who the user is displayed ... ... What I want is that upon opening the form ... ...
    (microsoft.public.access.forms)
  • Re: Select or Filtering on a related group
    ... >> Binding. ... >> You could bind all three objects, the Securities ComboBox, the Exchanges ... > this to Filter the ExchSec DataView.. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: vba sort a query
    ... I have many comboboxes with different selections and I have this code ... that i have on a 'filter' button so when I click the filter the ... comboboxes but sort by what is selected in the sortby combobox. ... Dim strdoc As String ...
    (microsoft.public.access.formscoding)
  • Re: Select or Filtering on a related group
    ... > ComboBox and the ExchSec grid to three separate DataView objects, ... > clicks a row in the grid, you can grab the exchange value (which can not be ... this to Filter the ExchSec DataView.. ... > Think about the complexity of what you're talking about in terms of binding. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: datagrid combobox question
    ... combobox you will wind up changing values in rows that arent being edited. ... So what you need to do is just before the combobox is displayed you need to ... What I want to do is to filter the list of Locations in the combo box to ... > If you bind the data you will wind up changing the values in multiple ...
    (microsoft.public.dotnet.languages.vb)