Populate subform based on 2 fields

[jmhicsupt]

I have a main form and a subform. I need to populate a field based on the value of two other fields – one field resides in the main form and one field resides in the subform.

Mainform field: SaleType
Subform field: ProductType
Field to be populated (resides in the Subform): OrderNumber

Here’s the criteria:

If Mainform.SaleType = Existing
And if subform.ProductType = “Apples”
The subform.OrderNumber = “red”

What is the code for this and where would I put the code?

Thanks in advance.

 

[HandsOnAccess]

You can place this code in Subform
Event : OrderNumber_AfterUpdate

Private Sub OrderNumber_AfterUpdate()
   If IsNull([Forms]!Mainform.SaleType)=True Then
      msgbox "Please Select SaleType"
      Exit Sub
   End If

   If IsNull(Me.ProductType)=True Then
      msgbox "Please Select ProductType"
      Exit Sub
   End If

   If [Forms]!Mainform.SaleType = Existing And Me.ProductType = “Apples” Then
       me.OrderNumber = “red”
   End If
End Sub

Regards,

 

[jmhicsupt]

Thanks - this worked great.