asked on

Query on load cmd

Can I have the filter by form button run as soon as query opens?

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

-Gil

ASKER

Where do I put this in a query I dont see a load or open event.

Jeffrey Coachman

One of the reasons why queries are used, is for filtering.

So you could also add whatever you are trying to filter for as the Criteria.

(Or am I missing something)?

JeffCoachman

-Gil

ASKER

I would like the query to open and appear like the screen shot below.
It will not be used in a form or report.

On load I would like it to open with the FILTER BY FORM button pressed.

Like mbizup posted above with the docmd.RunCommand acCmdFilterByForm.
I see how that works for a form or report but I would like the query to start like that.

-gil

QuerypicEE.bmp

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

-Gil

ASKER

Curious.
Why wouldn't you want the points?
-gil

Jeffrey Coachman

Gil,

"Why wouldn't you want the points?"

1. Because the solution is mbizup's, not mine.
2. I don't really care about the points.
4. You have given me enough points! ;-) LOL!
3. I did this just to help out

So give the full points to mbizup

;-)

Jeff

mbizup

Jeff,

Thanks.

-Gil
Sorry for being absent on this one. I've been swamped today. When I posted, I had misread "as soon as query opens" as "as soon as Form opens".

I'd be happy with any point allocation you decide on. I have a lot of points and still can't trade them in for a steak dinner. :)

-Gil

ASKER

4. You have given me enough points! ;-) LOL!

So so true lol

Still gave you 20 to highlight the post