I have an update query that updates a table based on a form I created. It currently works but I want to switch the column that is displayed in the table. For example:
I have the field names Food and Food ID. "Sandwich" falls under Food and its ID is "1". When I put "Forms.Food_Form.Food" in the "Update to" part of the query, in the table under Food it says "1" instead of "Sandwich". I tried putting "Forms.Food_Form.Food.Column(1)" which has worked in VBA code, but in the query it results in an error. Is my syntax wrong or what? Thanks in advance for help.
I have the field names Food and Food ID. "Sandwich" falls under Food and its ID is "1". When I put "Forms.Food_Form.Food" in the "Update to" part of the query, in the table under Food it says "1" instead of "Sandwich". I tried putting "Forms.Food_Form.Food.Column(1)" which has worked in VBA code, but in the query it results in an error. Is my syntax wrong or what? Thanks in advance for help.
