Referencing fields in subform

[Sandy]

I am attempting to reference the values in a subform - the main form is
"Finalise Jobs" the subform is "FinaliseJobDetailsSubform". I have tried the
following :-

"strMessage = strMessage & vbCrLf & "Repair Type - " _
& [Finalise Jobs].[FinaliseJobDetailsSubform]![cboCatName] _
& " Item - " & [Finalise
Jobs].[FinaliseJobDetailsSubform]![txtQuantity] & "x " _
& [Finalise Jobs].[FinaliseJobDetailsSubform]![cboRepProduct]"

but receive error :-

Number - "2465" and Description - "Microsoft Office Access can't find the
field '|' referred to in your expression."

Any suggestions?
Sandy

 

[Sandy]

Cracked it!

Finally found a web article that had the correct syntax. This works if you
are interested

strMessage = strMessage & vbCrLf & "Repair Type - " _
& Forms![Finalise Jobs]![FinaliseJobDetailsSubform].Form.cboCatName
& _
" Item - " _
& Forms![Finalise Jobs]![FinaliseJobDetailsSubform].Form.txtQuantity
& "x " _
& Forms![Finalise
Jobs]![FinaliseJobDetailsSubform].Form.cboRepProduct

Sandy