Linking a Field in a Form to a Calculating Field in a SubForm (1 Viewer)

B

Big D

Registered User.
Local time
Today, 08:12
Joined
Jul 6, 2019
Messages
32
mike60smart said:
Hi Big D

Your Projects has the value 70 for Billing Rates

Your Tasks Subform has the values as follows:-

Material Cost = 100
Outside Services Cost = 100
Labor Hrs = 6

What value do you want to see displayed ?
Click to expand...

Hi mike60smart,

I need to have the subform sheet that's embedded in the main form get the cost data from the Task Details form which currently shows $620. If we can get the subform sheet cost (which is currently manually entered in the subform $550 to show $620 instead), then the Total Task Cost in the footer will show $620. And this is what I need. Basically, looking for the subform cost to automatically update to whatever the cost value is in the Task Details form.

Thanks a bunch for all your help!!! I think I owe ya a case of beer!!

Big D
 
B

Big D

Registered User.
Local time
Today, 08:12
Joined
Jul 6, 2019
Messages
32
mike60smart said:
Hi

I added the calculation to the query that the TasksSubform is based on.

See if this suits
View attachment 75453
Click to expand...

Hi mike60smart,

Thanks very much for your help. Unfortunately, what I need the database to update is different. I put together a very brief zipped file explaining what I need to have the database do. Please let me know if I need to clarify more. Thanks again for all your help Mike.

Cheers,
Big D
 

Attachments

  • Doc2.zip
    117.9 KB · Views: 147
You must log in or register to reply here.

Similar threads

G
Hide a field in Subform (Datasheet) form based on Form Value
Replies
5
Views
215
Pat Hartman
P
M
Display subform confrol total to mainform
Replies
18
Views
463
Cotswold
Cotswold
M
Entwr records with form and subform.
Replies
11
Views
473
moi
M
B
Update main form text boxes as subform is filled in? Also, subforms not linking?
Replies
4
Views
437
gemma-the-husky
gemma-the-husky
A
Solved Problem scrolling on form with a tab control
Replies
10
Views
506
AlliCarr
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom