Would DLookup() work better here?

[eww]

Longer explanation is here: https://www.accessforums.net/program...view-8186.html
Short summary is I've got a subform in a datasheet form that pulls total weights of segments in from a totals query. I set a field in the form equal to the subform field because I can't set it directly.

I was wondering if the DLookup function work better here for what I want to accomplish. I was thinking something along the lines of:

Me.DetailedWeight = DLookup("[SumOfWeight]", "qrySegmentWeights",  _
"'[Segment] =" & Forms!sfrmSegments!Segments'" AND  _
"'[JobNumber] =" & Forms!sfrmSegments!JobNumber'")

But I'm not exactly sure how to write it, or if this is even a correct way of solving my problem.

[pbaldy]

Not clear on what you're doing, but to correct the syntax:

Me.DetailedWeight = DLookup("[SumOfWeight]", "qrySegmentWeights", "[Segment] ='" & Forms!sfrmSegments!Segments & "' AND [JobNumber] ='" & Forms!sfrmSegments!JobNumber & "'")

which assumes both fields are text. I'd recommend getting it working all on one line, then breaking it onto multiple lines if you want. One hurdle at a time.

Also, if that's a subform as the name implies, the syntax is off:

Forms Refer to Form and Subform properties and controls

[eww]

Oh you're right, I'm familiar with subform syntax I just forgot it in there. I haven't tried this code yet I was just putting it up here to see if anyone had any thoughts on the correct way to do this.

I'm trying to have a in one form two subforms, one is for submittals, one is for segments. The segments are like categories that you can pick when entering the submittals. I'm trying to total the submittals by segment (or category) and show that total on the segments subform (which is in datasheet view). I'm attaching a picture because I'm thinking this is probably difficult to understand from my descriptions. Right now I have the weights from the submittals totaling in a query, and then I have a subform in the Segments subform that pulls in the total weights for each Segment. I then set the Detailed Weight for each Segment equal to the weight for the respective segment in the subform.

Thanks for the help with the syntax