Placing into a respective row cell of sub form

[Reshmi mohankumar]

How can I paste the value of respective sub-subform.sum[field], in to a cell of a respective row of sub form !?

 

[Mark_]

Can you please restate the question?

I am unsure what your reference to "Cell of a respective row" would be.

Do you mean "Update a field in a table"?

 

[Reshmi mohankumar]

Attachment below

 

[Reshmi mohankumar]

Can you please restate the question?

I am unsure what your reference to "Cell of a respective row" would be.

Do you mean "Update a field in a table"?

Yes , attachment give you relationship

 

[JHB]

You shouldn't store calculated values, but calculate them at runtime, each time you need them.

 

[Reshmi mohankumar]

You shouldn't store calculated values, but calculate them at runtime, each time you need them.

Yes , your right. I need runtime calculate for each row

 

[Minty]

No, you don't need runtime, you need to not store those values.
Simply create a query that calculates the values and use that.

 

[Reshmi mohankumar]

Yes , attachment give you relationship

this will show you how i want to copy the value from main form to a perticular field in sub form

 

[Reshmi mohankumar]

Can you please restate the question?

I am unsure what your reference to "Cell of a respective row" would be.

Do you mean "Update a field in a table"?

i need to put the below text box value in to above subform LESSWT field , and this will be repeat for each row of a above subform. will you plz help me...??

 

[Reshmi mohankumar]

You shouldn't store calculated values, but calculate them at runtime, each time you need them.

ok. thank you

 

[Mark_]

Is the data source for your form?

IF it is a query, you can calculate in your query.
IF it is directly to the table, you should change to use a query.

 

[Reshmi mohankumar]

Is the data source for your form?

IF it is a query, you can calculate in your query.
IF it is directly to the table, you should change to use a query.

Yes, I have tables,

 

[Mark_]

Yes, I have tables,

Use Query.

Put the calculation in the query.

DO NOT store in your table.