update query from forms to table and back to form

M

Makelei

Hi,
I'm using Access 2003 and XP.

I have form named "Main" which contains subform "BaselineSumQuerySbForm".
"BaselineSumQuerySbForm" is visible as datasheet and in footer of that
subform is calculation based on filtering in different fields e.g. "B7".
There are two kind of units used "FTE" and "HC".

On "Main" form I ave text boxes showing the value of subform values e.g
"=BaselineSumQuerySbForm.Form!B7".

I need to get these values into format that values can be copied futher to
excel or powerpoint. -> the values needs to be in datasheet format. How could
I get these values into a table and visible in form as datasheet?

I have thought it would be best to create update query like:
DoCmd.RunSQL ("Update BaselineSummaryT Set [2009/07]=" &
Form![BaselineSumQuerySbForm]![B7] & ", [2009/08]=5 Where ID=1") 'FTE

But I cannot figure out how to get the value from subform to this:
" & Form![BaselineSumQuerySbForm]![B7] & ". If I use number like
"[2009/08]=5" it goes right, but number 5 should be linked to field and is
changing. What am I doing wron in referencing the field? What would be the
best way to do it? There are calendar months and each month has two values
coming from thos fields.

Thanks in advance
Makelei
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Adding data to MS Access from csv file 0
Creating a Chart on form from selected data in query. 0
Dataview based form + single form subform 0
form subform 0
specifying which subdatasheet in Access 2003 3
Minimize datasheet view after update 0
Need cancel-save function on main form for datasheet subform 0

Top