Referring to field in subform

[LeizladNeb]

I have a button in a sub form called [frmJob] which has been made from [tblJob]. The button runs the following code with the intention of finding the number of items in [tblItem] which have the same [JobNo], and also totalling their total values.

Private Sub Command28_Click()
[ItemsInJob] = DCount("[tblItem]![ItemNo]", "tblItem", "[tblItem]![JobNo]=[tblJob]![JobNo]&quot
[JobValue] = DSum("[TotalItemValue]", "tblItem", "[tblItem]![JobNo]=[tblJob]![JobNo]&quot
End Sub

An error returns on clicking the button:

'The object doesn't contain the Automation Object 'tblJob!JobNo."

The error doesn't occur and the code works fine when I open frmJob on its own, i.e. not as a subform, so im guessing its a reference thing. Any ideas?

Thanks Ben Dalziel

 

[JeremyNYC]

Well, I don't see where you're refering to a form anywhere, but here's how you refer to a control on a subform:

forms!NameOfMainForm!NameOfControlThatHoldsTheSubform.form!NameOfTargetControl

If you do a search on this site for "refer to a control on a subform" you'll find several nearly identical answers.

Jeremy ==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.