Problem with form button

[Jeremiah]

I have created a form that will be used as a simple push button interface for
users not familiar with access. (like a swichboard) It works fine but as soon
as I add a button with an imbedded macro that runs a filter on a report a few
problems arise. With the button present the form loads extremely slow. I have
noticed that can scroll through records at the navigation on the bottom of
the form.(1100 seperate forms and I only want 1) It all looks the same as
this is not a data entry form. The number of records at the bottom is the
exact number or records that would be in the reprot filtered by the
macro/button. Why is this happening and how can I prevent it?

 

[Jeremiah]

Does anyone understand my problem. The filter seems to be running as soon as
the form is opened.

 

[Brendan Reynolds]

Does anyone understand my problem. The filter seems to be running as soon
as
the form is opened.

Well from your description it would appear that a) the form is bound to a
table and b) the filter is being applied to the form instead of, or as well
as, to the report. More than that I can't really say without knowing what
your macro does. If you can post the details of what the macro does, perhaps
someone might be able to help you. Probably not me, as I don't do macros,
but perhaps someone else may be able to help.

 

[Jeremiah]

The macro that I am using is quite simple. It is an imbeded macro that is
supposed run when the button is clicked. Basicaly it takes an exiting report
and applys a filter to it. The filter is a query I have ritten. I have also
tried doing this another way by using a where statement with in the macro but
get the exact same results. Whenever I open the form It shows that a query is
running in the status bar at the bottom of the screen.