Update query- Access 2010 Win7

aziska

New Member
Joined
Feb 15, 2012
Messages
13
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:

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top