How do I suppress the #Error from the (New) record line in a datasheet ? Thank you in advance.
M music_al Registered User. Local time Today, 15:37 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 Today, 10:37 Joined Apr 9, 2015 Messages 4,337 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, 15:37 Joined Feb 19, 2013 Messages 16,685 Nov 2, 2018 #3 perhaps something like =dlookup("somefield","sometable","[ID]=" & nz(me.ID,0))