Help with a form

Coll

I'm working on a form that generates a query that the user can export
(I'm not working with reports - just with queries). The form allows
the user to filter the data using several fields. One of the fields is
ethnicity. So you can generate data of just white employees, of just
asian, etc. One of the users has asked me if I can set up a new option
of selection just minorities (which would be maybe 6 out of the 7
fields). I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Any suggestions. I'm not super technical, so if it involves lots of
programming, it might be over my head. Can follow some straightforward
code (case statements, if statements etc.)

Aug 4 '08 #1

Keith Wilby

"Coll" <co*********@hotmail.comwrote in message
news:dc**********************************@x41g2000 hsb.googlegroups.com...

I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Right-click on "white" then choose "filter excluding selection".

Keith.
www.keithwilby.com

Aug 4 '08 #2

Coll

On Aug 4, 9:33*am, "Keith Wilby" <h...@there.comwrote:

"Coll" <col_mcma...@hotmail.comwrote in message

news:dc**********************************@x41g2000 hsb.googlegroups.com...

I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Right-click on "white" then choose "filter excluding selection".

Keith.www.keithwilby.com

Hi - the user is working on a form with a pull-down that currently
lists each ethnicity. They select the ethnicity and then a query is
displayed with the results. The users are not sophisticated enough to
use filter excluding - I'm trying to modify my form so that it will do
the filter excluding for them - just not sure how to get it to work
using the form & the query.

Aug 4 '08 #3

Salad

Coll wrote:

On Aug 4, 9:33 am, "Keith Wilby" <h...@there.comwrote:

>>"Coll" <col_mcma...@hotmail.comwrote in message

news:dc**********************************@x41g20 00hsb.googlegroups.com...

>>>I've played around a bit with this, but I'm having difficulty
figuring out how to manipulate the form/query so that all but white
employees display (while still retaining the option of displaying just
one ethnicity).

Right-click on "white" then choose "filter excluding selection".

Keith.www.keithwilby.com

Hi - the user is working on a form with a pull-down that currently
lists each ethnicity. They select the ethnicity and then a query is
displayed with the results. The users are not sophisticated enough to
use filter excluding - I'm trying to modify my form so that it will do
the filter excluding for them - just not sure how to get it to work
using the form & the query.

You could use a pull down or listbox. In my form's header I may have
one or many items to filter on. In the AfterUpdate event of each item
to filter on I have this line in it
SetFilter
The sub then checks my items to filter on and builds a filter string. Ex:
Sub SetFilter
Dim strFilter As String
If Me.CheckActive then
strFilter = "OrderActive = True And "
Endif
...more filter checks
If strFilter "" Then
'remove trailing "And"
strFilter = Left(strFilter,Len(strFilter)-5)
Endif
Me.Filter = strFilter
Me.FilterOn = (strFilter "")
End Sub

Aug 4 '08 #4

Keith Wilby

"Coll" <co*********@hotmail.comwrote in message
news:b6**********************************@m44g2000 hsc.googlegroups.com...

The users are not sophisticated enough to use filter excluding

So you're saying that your users aren't capable of using the right mouse
button?

Aug 5 '08 #5