Hi
On the mainform I have a textbox with the following control source =[sfAgedDebt].Form![TotalDue] which is working fine however if TotalDue on the subform is blank the text box on the mainform displays #Error would anyone be able to help me stop the #Error message showing and the Textbox to be blank if the subform is blank ?? as always thanks for your help cheers Fi
On the mainform I have a textbox with the following control source =[sfAgedDebt].Form![TotalDue] which is working fine however if TotalDue on the subform is blank the text box on the mainform displays #Error would anyone be able to help me stop the #Error message showing and the Textbox to be blank if the subform is blank ?? as always thanks for your help cheers Fi