Update query- Access 2010 Win7

[aziska]

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:

 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.

 

[aziska]

Re: Help

This is something that you can do if you set the action (update) to run on a given action (buttion click, etc.) Can you better describe what it is you're trying to do?

i.e. Tell us what you want your form to have on it, what you want the queries to be doing and table names, field names etc. would be helpful.