sending a query expression from a form to a query?

S

shanej

I am trying to send a query expression from a form to the underlying
query. the field type in the underlying query is date/time. Does anyone
have an example how to do this?

Here is what I've tried.

the query contains the following criteria for a field:
Like [forms].[formname].[combo22]

on the form the combo box draws its contents from a table where the
expresions are contained, i.e.

"*"
Is Null
"*" OR Is Null

it's not working though. any help would be great.
 
S

shanej

it seems the biggest problem here is that I have to use "Like" in the
expression. which does not work with "Is Null."
so, how can I place an expression with out using "Like"?

I tried
=[forms].[formname].[combo22]
but no go.

any ideas?
 
G

geebee

hi,

It should work just fine IF:

1. the form's field is formatted as a date
2. the form is open, even if it is invisible..it just has to be open
3. the focus has moved to another control on the form AFTER the criteria
date has been typed in

Hope this helps!

geebee
 
Top