PLEASE HELP. Repost.

[Sue]

I want to develop a form that has a command button which will open a
parameter query. The parameter is a date field. There are 3 dates:
"ScreeningDate", "ICFDate", and "D1Tx", each of which is drawn from a table.
I need to be able to open the query if any of those 3 fields are equal to or
greater than a given date.

I'm thinking my first step is to add a new field to my parameter query which
says something like ". Include any records in which "ScreeningDate",
"ICFDate", or "D1Tx" is > or = such-and-so a date. How do I do that, and then
how do I make the command button do what I'm asking it for?

I can't post to the discussion board any more, by the way, from my new
laptop or from my work machine. . I can't respond to posts or ask a new
question, nor can I even sign out (to try logging back in). I have allowed
pop-ups for the site on both machine. The only thing I can guess is this:
I've recently gotten a new computer. The old one is still in daily use. Since
getting the new machine, each time I log on I get a popup box indicating that
I can't sign in to net password as I'm signed in elsewhere. Please help with
this if at all possible.

You may respond to me directly at (e-mail address removed) or, alternatively, I'll
check the old machine when I get back home tonight.

MANY THANKS FOR ALL YOUR HELP!!!

 

[xiaojun]

I want to develop a form that has a command button which will open a
parameter query. The parameter is a date field. There are 3 dates:
"ScreeningDate", "ICFDate", and "D1Tx", each of which is drawn from a
table.
I need to be able to open the query if any of those 3 fields are equal to
or
greater than a given date.

I'm thinking my first step is to add a new field to my parameter query
which
says something like ". Include any records in which "ScreeningDate",
"ICFDate", or "D1Tx" is > or = such-and-so a date. How do I do that, and
then
how do I make the command button do what I'm asking it for?

I can't post to the discussion board any more, by the way, from my new
laptop or from my work machine. . I can't respond to posts or ask a new
question, nor can I even sign out (to try logging back in). I have allowed
pop-ups for the site on both machine. The only thing I can guess is this:
I've recently gotten a new computer. The old one is still in daily use.
Since
getting the new machine, each time I log on I get a popup box indicating
that
I can't sign in to net password as I'm signed in elsewhere. Please help
with
this if at all possible.

You may respond to me directly at (e-mail address removed) or, alternatively,
I'll
check the old machine when I get back home tonight.

MANY THANKS FOR ALL YOUR HELP!!!

 

[scubadiver]

Off the top of my head:

on the form insert a textbox that accepts short dates and give it the name
[formdate]

In the query, include the three date fields.
In the 1st criteria row for the first field type >=[formdate]
In the 2nd criteria row for the second field type >=[formdate]
In the 3rd criteria row for the the field type >=[formdate]

In the form create the code that will open the query (using the wizard).

When the query is opened it will only include dates where the date is later
or equal to than what you specify.

That should give you what you want (or it is definitely a starting point)