One more try- Selecting blank field.

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

I have 3 combo boxs [Complete], [Followingup],[resolved]
that are used to filter a form by dates. The row source
for each field is queried form the MainData Table so the
user get only the dates that have already been entered.
The problem is the users would like to be able to sort
records that dont have any dates entered orders that
still need to be worked. I have no ideal how to make
this happen using a combo box that is selecting the date
from the maindata table. I can not use a default
like "1/1/1999" because I have controls in place that
locks the order from changes if the [resolved] date is
entered.
I am at my wits end and I hope someone can help me with
this. Below is the code that I am using to sort.
Thanks in Advance.
Raj
 
Raj,

why not add a button that shows incomplete orders. the filter that you then
pass is along the lines of
isnull([Complete]) etc
 
Stewart,
I am not sure how to do that.. I have 2 other filter and
I dont want those 2 to unfilter. Can you offer any
assistances.
Thanks
-----Original Message-----
Raj,

why not add a button that shows incomplete orders. the filter that you then
pass is along the lines of
isnull([Complete]) etc

I have 3 combo boxs [Complete], [Followingup], [resolved]
that are used to filter a form by dates. The row source
for each field is queried form the MainData Table so the
user get only the dates that have already been entered.
The problem is the users would like to be able to sort
records that dont have any dates entered orders that
still need to be worked. I have no ideal how to make
this happen using a combo box that is selecting the date
from the maindata table. I can not use a default
like "1/1/1999" because I have controls in place that
locks the order from changes if the [resolved] date is
entered.
I am at my wits end and I hope someone can help me with
this. Below is the code that I am using to sort.
Thanks in Advance.
Raj
Click to expand...


.
Click to expand...
 
Stewart,
I am not sure how to do that.. I have 2 other filter and
I dont want those 2 to unfilter. Can you offer any
assistances.
Thanks
Click to expand...

A Filter (like a WHERE clause in a Query) can have many fields in its
criteria, using OR or AND logic to join the terms. If you're assuming
one field = one filter, reconsider your assumption!
 
as John said you can have multiple fields to create a filter expression or
where clause.

so the filter is isnull([Complete]) and othercondition and othercondition

Stewart,
I am not sure how to do that.. I have 2 other filter and
I dont want those 2 to unfilter. Can you offer any
assistances.
Thanks
-----Original Message-----
Raj,

why not add a button that shows incomplete orders. the filter that you then
pass is along the lines of
isnull([Complete]) etc

I have 3 combo boxs [Complete], [Followingup], [resolved]
that are used to filter a form by dates. The row source
for each field is queried form the MainData Table so the
user get only the dates that have already been entered.
The problem is the users would like to be able to sort
records that dont have any dates entered orders that
still need to be worked. I have no ideal how to make
this happen using a combo box that is selecting the date
from the maindata table. I can not use a default
like "1/1/1999" because I have controls in place that
locks the order from changes if the [resolved] date is
entered.
I am at my wits end and I hope someone can help me with
this. Below is the code that I am using to sort.
Thanks in Advance.
Raj
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top