Hello,
I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where it would update with my entered information but now it brings up a window asking for the field's parameter. When I construct the query, i've used the expression builder and my code in SQL is this:
What might I be missing to tell the query to take the already entered data rather than re-ask me for it? Thank you so much for your help. Its appreciated in advance.
I'm attempting to perform an update query to a table for the field "periodyear" and "period" using a text box and a list box that live on a form in front of the database. The text box's name is Year_Label and the list boxs name is Quarter_Label. I've had this working at one point where it would update with my entered information but now it brings up a window asking for the field's parameter. When I construct the query, i've used the expression builder and my code in SQL is this:
Code:
UPDATE EQUI_H3_Export_Table SET EQUI_H3_Export_Table.periodyear = [Forms]![Opening Form]![Year_Label], EQUI_H3_Export_Table.period = [Forms]![Opening Form]![Quarter_Label];
What might I be missing to tell the query to take the already entered data rather than re-ask me for it? Thank you so much for your help. Its appreciated in advance.