i have an unbound form to save 1 field to 1 tabel
the code is like this :
if I used it with command button i can work successfully
but if i put in on trigger (form or text box) if cannot be done
I already put it on OnLookUp trigger, onValidate, on aftergetcurrrecord, etc
all failed… do you know which trigger i must used to solve problem like this?