C
CW
I have a Costing form with a several lines that include fields for Crates and
their Costs.
If a user enters a Crate on line 1 (Crate1) the related cost field
(Crate1Cost) should then be populated with the amount of 60.00.
However, on any lines that are NOT used, the cost should remain at the
default of 0.00.
In other words, the cost fields should only come alive if the preceding
Crate field on that line has been populated.
In an earlier post somebody suggested the following code, but unfortunately
it has no effect:
Private Sub Crate1_AfterUpdate()
If Not IsNull(Crate1) Then
Crate1Cost = 60
Else
Crate1Cost = 0
End If
End Sub
I'll be grateful for your comments
Many thanks
CW
their Costs.
If a user enters a Crate on line 1 (Crate1) the related cost field
(Crate1Cost) should then be populated with the amount of 60.00.
However, on any lines that are NOT used, the cost should remain at the
default of 0.00.
In other words, the cost fields should only come alive if the preceding
Crate field on that line has been populated.
In an earlier post somebody suggested the following code, but unfortunately
it has no effect:
Private Sub Crate1_AfterUpdate()
If Not IsNull(Crate1) Then
Crate1Cost = 60
Else
Crate1Cost = 0
End If
End Sub
I'll be grateful for your comments
Many thanks
CW