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:
    Tab
...