Hi I'm having trouble inserting data from a sub form into an email message. I have a cmd button to send the email from the main form and i have data on my main form & subform that i want to include my code works fine but im unsure how to insert the subform information. Any help would be greatly...
Thanks I have altered my code which now looks like this
Else
Insp = "Pass"
Status_Control = "2"
With Me!Fault_Data_subform.Form
.Recordset.MoveFirst
While Not .Recordset.EOF
!Problem = "No Problems - Job Approved"
.Recordset.MoveNext
Wend
End With
End If
But i now get a...
Hi Think i have got this in the right section.
I have a subform which is in datashet veiw and may return multiple records. Within this form i am trying to update the Problem feild in the subform which is a text box to "No Problems - Job Approved"
I am using an IF statement from the main...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.