If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
step through macros
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. |
#3
|
|||
|
|||
step through macros
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. |
#4
|
|||
|
|||
step through macros
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. |
Thread Tools | |
Display Modes | |
|
|