Using MS Access forms to update MySQL Tables using MySQL ODBC driver

I'm trying to use MS Access for the front end and MySQL as the Data source.

I have this MS Access form which uses a table called hotel:

With the "location" combo box linked to a table called "location".

The location combobox properties that i entered were:

• Row Source:
  SELECT [location].[location_id], [location].[name] FROM location;
• Row Source Type:
  Table/Query

I can see the values and select them from drop down list and go to the next records,
but the problem is, it doesn't update the record on the location table.

What am i doing wrong here?

Any help will be greatly appreciated..

re: Using MS Access forms to update MySQL Tables using MySQL ODBC driver

Sorry this reply is so late - probably won't help you now. The most likely explanation for the value not being kept is that your combo box is not bound to a field from your underlying table. It is easy to make this mistake when using the combo wizard to create the combo for you.

You will know for sure if you check the Control Source property of the combo. I would guess you will find that it is blank at present. If it is, you should set the name of the control source to be the name of the field in which you want to store the value selected from the combo.

-Stewart