how can I write module to run update query that has popup dialog box.

[acin0026]

Hello

Question 1
In module, how can I write module to run update query that need to pop up parameter dialog box to get data from user?

Question 2
How can I write module to run macro?

thanks.

 

[ninash]

1. I might be getting old but the field you require the input from the user would just have the parameter listed as you would use it normally.

2. include the line
DoCmd.RunMacro "Macro1", , ""

Where Macro1 is the name of your macro

I am not sure if this is at all helpful but if it is let me know

 

[Cagliostro]

Also you can do
DoCmd.RunSQL YourTextControlNameFromYourForm John Fill

ivfmd@mail.md