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