Vb Statement quit working

[billheath]

I am perplexed but sure I am Doing something wrong!
The following code was working but now I get the error .. "Object doesn't support this property or method."

Private Sub Buy_BeforeUpdate(Cancel As Integer)
If Me![BUY] < Forms.Stock_Data![Lowest] Then
Forms.Stock_Data![Lowest] = Me![BUY]
End If
If Me![BUY] > Forms.Stock_Data![Highest] Then
Forms.Stock_Data![Highest] = Me![BUY]
End If


End Sub

If I make a change in the first form, I want to be able to replace a value in another table. Please help. I hope this makes sense! Bill

 

[PHV]

I'd replace this:
Forms.Stock_Data
with this:
Forms!Stock_Data

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886