Newbie(ish) question:
The title is the what I'm trying to do. This is what I have done that works BUT if anyone accidentally clicks on, tabs through, or enters the field, it puts in the data from the related field. I want it to save any new data and not allow any accidental changes.
Private Sub CASE_COST_Enter()
[CASE_COST] = [CASE_COST2]
End Sub
Case_Cost is a field in a new PO form. Case_cost2 is from a query that lists last purchase price.
Any suggestions?
TIA
CS