M music_al Registered User. Local time Today, 03:25 Joined Nov 23, 2007 Messages 200 Nov 2, 2018 #1 How do I suppress the #Error from the (New) record line in a datasheet ? Thank you in advance.
Ranman256 Well-known member Local time Yesterday, 22:25 Joined Apr 9, 2015 Messages 4,348 Nov 2, 2018 #2 Fill in the record. A calculated field can read unsaved fields.
C CJ_London Super Moderator Staff member Local time Today, 03:25 Joined Feb 19, 2013 Messages 17,754 Nov 2, 2018 #3 perhaps something like =dlookup("somefield","sometable","[ID]=" & nz(me.ID,0))
