arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 21:18
- Joined
- May 7, 2009
- Messages
- 20,516
it's because on New record, there is No athltID yet, try this:
=Dlookup("Onoma", "tbl_Tmimata", "tmimaID = " & Nz(DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & Nz([atheltID], 0)), 0))
=Dlookup("Onoma", "tbl_Tmimata", "tmimaID = " & Nz(DLookUp("tmimaID","Tbl_StelehosiTmimaton","atheltID=" & Nz([atheltID], 0)), 0))
