Running query from a Command button

[Guest]

i have a command buttons on a form which have been given the instructions
with an on click event to run a macro to open another form that has been
created from a query. the query has criteria to only display a certain range
of data.

this works ok.

i have then added a second command button on the form, to run another macro
(different name) on the on click event and this is to open the same form but
with different criteria settings.

this works ok BUT the first button then takes on the macro of the second
button and when that is clicked it gives the results of the second button.

has any one know a solution to this. i thought they should remain separate
commands / actions as the buttons are not copied, the macros are different
names.

any ideas would be gratefully received

tom

 

[Van T. Dinh]

They are separate so running the Macros for the first Command Button should
not run the Macros thats was meant for the second CommandButton.

If you are using the *same* Macro Group, i.e. storing both in the same Macro
container as seen in the Macros tab of the Database window, try storing them
in different Macro Group ...