How to update records in an Access subform based on a query?

I have an access form which uses a query looking into the SQL database (using connection string via ODBC). When I load the form, I can only view the data in each record. How can I make my form allow changing the values of the existing record fields, or adding new records?

Among the form properties, the "Allow Additions", "Allow Deletions", "Allow Edits", and "Allow Filters" are all set to "yes". I have tried all the possibles values for "Data Entry" and "Record Lock" but no luck.

Help is appreciated.