pls help me on this..
i'm using this code to get data from record:
MyNum1 = DLookup("[Outcome]", "Remark", _ "[IDRemark] = Form![SelectTxt]") OutTxt.Value = MyNum1
my prob is when the data in [Outcome] is null , access having error to still get the null value from the record..
how to deal with this, do I need to put default value for [Outcome] field in case user don't wanna put data in it? or is there other way to handle?