 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008step 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?  SignatureMaurice Ausum > 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. > Try converting the macro to VBA and step through it from there. > What version are you using? > > > 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 SignatureSteve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) > 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 [quoted text clipped - 7 lines] > > > activated via a macro. How can the macro be stepped through and then how do > > > I verify what has been passed to the query. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.