W
WPW07
Hello Everyone,
I'm using Access 2003. I manually set up an ODBC connection to a
MySQL table using MySQL ODBC Driver 3.51. I then linked to the MySQL
table using that ODBC connection and created a query from that MySQL
table. I created a query for a combo box on a form that is bound to
that query. This works fine for testing purposes. But when I roll
this out, I'd like to have some VBA code in the OnClick event of the
combo box that connects to the MySQL database, then queries the MySQL
table to populate the combo box list.
I'm a little rusty with VBA coding, so I was reaching out for some
help. Can anyone get me started in the right direction?
Thanks for any help!
I'm using Access 2003. I manually set up an ODBC connection to a
MySQL table using MySQL ODBC Driver 3.51. I then linked to the MySQL
table using that ODBC connection and created a query from that MySQL
table. I created a query for a combo box on a form that is bound to
that query. This works fine for testing purposes. But when I roll
this out, I'd like to have some VBA code in the OnClick event of the
combo box that connects to the MySQL database, then queries the MySQL
table to populate the combo box list.
I'm a little rusty with VBA coding, so I was reaching out for some
help. Can anyone get me started in the right direction?
Thanks for any help!