Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 run query through vb procedure

Author  Topic 

kalsee
Starting Member

5 Posts

Posted - 2010-12-20 : 06:50:37
I have a form through which I ask the user to add in some information, which I then want to use to modify a record in a table.
I created a query which does this modification, but how do I run this query through the vb procedure "onclick"?

Thanks for your time.

nheidorn
Starting Member

28 Posts

Posted - 2010-12-20 : 14:41:00
There are several ways to accomplish this. Take a look at DoCmd.RunSQL method in the Access help file. You could also create a macro to run your query and connect that to the command button. The vb solution is much more flexible though.
Go to Top of Page
   

- Advertisement -