 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008Referencing fields in subform
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 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 >I am attempting to reference the values in a subform - the main form is >"Finalise Jobs" the subform is "FinaliseJobDetailsSubform". I have tried [quoted text clipped - 13 lines] > Any suggestions? > Sandy |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.