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 form.This works fine but only updates one record how can i ensure all records within the subform are updated? Any help will be much apprciated.
If QtyOfFaults > 0 Then
Insp = "Fail"
Status_Control = "1"
MsgBox "Enter problem against part number", vbInformation, "Error's"
Else
Insp = "Pass"
Status_Control = "2"
Me.Fault_Data_subform.Form!Problem = "No Problems - Job Approved"
End If
End Sub
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 form.This works fine but only updates one record how can i ensure all records within the subform are updated? Any help will be much apprciated.
If QtyOfFaults > 0 Then
Insp = "Fail"
Status_Control = "1"
MsgBox "Enter problem against part number", vbInformation, "Error's"
Else
Insp = "Pass"
Status_Control = "2"
Me.Fault_Data_subform.Form!Problem = "No Problems - Job Approved"
End If
End Sub