sending a query expression from a form to a query?

  • Thread starter Thread starter shanej
  • Start date Start date
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.
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use In() Expression as Query criteria with guts from Function 1
Default Query Criteria 1
Multiple Parameter Crosstab query filter by form 1
Pull criteria from a Form 2
Query by Form 3
Query driven by form field 1
Access Determine what query to run based on a checkbox 0
iif function syntax problem 5

Back
Top