step through macros

I need to verify what is being passed to a query from a form. This action is
activated via a macro. How can the macro be stepped through and then how do
I verify what has been passed to the query.

Try converting the macro to VBA and step through it from there.
What version are you using?
--
Maurice Ausum


"bindurajeesh" wrote:

I need to verify what is being passed to a query from a form. This action is
activated via a macro. How can the macro be stepped through and then how do
I verify what has been passed to the query.

i am useing access 03. the macro only has one step which requerys the row
source for the list box. the query for the list box to be filled has an id
from another list box within the where aspect of the query. I need to
determine what is being passed to the where clause.

"Maurice" wrote:

Try converting the macro to VBA and step through it from there.
What version are you using?
--
Maurice Ausum


"bindurajeesh" wrote:

I need to verify what is being passed to a query from a form. This action is
activated via a macro. How can the macro be stepped through and then how do
I verify what has been passed to the query.

I don't use macros, but I can think of two ways:

1) have an unbound text box that is updated when the source list box has a
value selected. Delete the text box after it is working right

2) use a message box that displays to evalue of the list box when the macro
is run (before the requery).

HTH
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"bindurajeesh" wrote:

i am useing access 03. the macro only has one step which requerys the row
source for the list box. the query for the list box to be filled has an id
from another list box within the where aspect of the query. I need to
determine what is being passed to the where clause.

"Maurice" wrote:

Try converting the macro to VBA and step through it from there.
What version are you using?
--
Maurice Ausum


"bindurajeesh" wrote:

I need to verify what is being passed to a query from a form. This action is
activated via a macro. How can the macro be stepped through and then how do
I verify what has been passed to the query.