Placing into a respective row cell of sub form (1 Viewer)

Reshmi mohankumar

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 5, 2017

• #1

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

 

M

Mark_

Longboard on the internet

Local time

Today, 11:58

Joined

Sep 12, 2017

Messages

2,111

• Dec 5, 2017

• #2

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

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 6, 2017

• #3

Attachment below

 

Attachments

• 
  questions.jpg

  100.9 KB · Views: 103

Reshmi mohankumar

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 6, 2017

• #4

Mark_ said:

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"?

Click to expand...

Yes , attachment give you relationship

 

Attachments

• 
  questions.jpg

  100.9 KB · Views: 52

J

JHB

Have been here a while

Local time

Today, 20:58

Joined

Jun 17, 2012

Messages

7,732

• Dec 6, 2017

• #5

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

 

Reshmi mohankumar

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 6, 2017

• #6

JHB said:

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

Click to expand...

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

 

Minty

AWF VIP

Local time

Today, 19:58

Joined

Jul 26, 2013

Messages

10,371

• Dec 6, 2017

• #7

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

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 7, 2017

• #8

Reshmi mohankumar said:

Yes , attachment give you relationship

Click to expand...

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

 

Attachments

• 
  query.JPG

  89.7 KB · Views: 51

Reshmi mohankumar

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 8, 2017

• #9

Mark_ said:

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"?

Click to expand...

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...??

 

Attachments

• 
  query.JPG

  89.7 KB · Views: 40

Reshmi mohankumar

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 8, 2017

• #10

JHB said:

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

Click to expand...

ok. thank you

 

M

Mark_

Longboard on the internet

Local time

Today, 11:58

Joined

Sep 12, 2017

Messages

2,111

• Dec 8, 2017

• #11

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

Registered User.

Local time

Tomorrow, 00:28

Joined

Dec 5, 2017

Messages

101

• Dec 8, 2017

• #12

Mark_ said:

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.

Click to expand...

Yes, I have tables,

 

M

Mark_

Longboard on the internet

Local time

Today, 11:58

Joined

Sep 12, 2017

Messages

2,111

• Dec 8, 2017

• #13

Reshmi mohankumar said:

Yes, I have tables,

Click to expand...

Use Query.

Put the calculation in the query.

DO NOT store in your table.