Good morning!
I have a database that tracks our departments preformace measures. We call them "widgets". The system is devveloped and maintained by a higher section in our org. Bottom line .. my unit produces graphs and other things based on this data. as time goes these widget functions change names and or pourpose. So I came up with a database that takes all this data and crunches it into a format we can easly aoutomatically produce graphs for our section managers.
Now the problem. I have to for current and historical reasons have a widget map to tell the database the new functions and the old so it knows how and where to add them(crosstalk table). I can do it no problem but I want a novice user to do it so I am not involved. Hence a Update query using a form.(there could be a better way of doing this) So my table set up is newwidgetfunction oldwidgetfuntion and section. with a higher level table listing only newwidgetfunctions and section only. I want the newwidgetfunction on top of form and oldewidgetfunction and section on subform.(one to many). My vb code to run the query is fine just cant get the update qury to update anything. I have included all the screen shots of what I have so far. I just threw the form together so ill pretty it up when working. here is the sql version of the query...UPDATE tblcombine SET tblcombine.newwidgetfunction = [Forms]![frmwidgetcombine]![newwidgetfunction]
WHERE (((tblcombine.oldwidgetfunction)=[Forms]![frmwidgetcombine]![functiondrop]) AND ((tblcombine.Section)=[Forms]![frmwidgetcombine]![section]));
I have a database that tracks our departments preformace measures. We call them "widgets". The system is devveloped and maintained by a higher section in our org. Bottom line .. my unit produces graphs and other things based on this data. as time goes these widget functions change names and or pourpose. So I came up with a database that takes all this data and crunches it into a format we can easly aoutomatically produce graphs for our section managers.
Now the problem. I have to for current and historical reasons have a widget map to tell the database the new functions and the old so it knows how and where to add them(crosstalk table). I can do it no problem but I want a novice user to do it so I am not involved. Hence a Update query using a form.(there could be a better way of doing this) So my table set up is newwidgetfunction oldwidgetfuntion and section. with a higher level table listing only newwidgetfunctions and section only. I want the newwidgetfunction on top of form and oldewidgetfunction and section on subform.(one to many). My vb code to run the query is fine just cant get the update qury to update anything. I have included all the screen shots of what I have so far. I just threw the form together so ill pretty it up when working. here is the sql version of the query...UPDATE tblcombine SET tblcombine.newwidgetfunction = [Forms]![frmwidgetcombine]![newwidgetfunction]
WHERE (((tblcombine.oldwidgetfunction)=[Forms]![frmwidgetcombine]![functiondrop]) AND ((tblcombine.Section)=[Forms]![frmwidgetcombine]![section]));
