Hi guy's
I have a form called 'costings' which works out cost - VAT - PLUS VAT ect..
I have the problem where in for example -Property Sheet - Data - Control Source =[CRMCost]*0.2
Because it doesn't have a name 'txtCost' I can not write VBA to clear these boxes 'TextBox,ComboBox,CheckBox,ListBox'
I'm not interested in Me.TxtCost.Value = ""
I just want a click button that I can 'Call' from a Public Function that will clear all boxes from any form that I would like to clear, on any given form.
Kind regards,
Neil.
I have a form called 'costings' which works out cost - VAT - PLUS VAT ect..
I have the problem where in for example -Property Sheet - Data - Control Source =[CRMCost]*0.2
Because it doesn't have a name 'txtCost' I can not write VBA to clear these boxes 'TextBox,ComboBox,CheckBox,ListBox'
I'm not interested in Me.TxtCost.Value = ""
I just want a click button that I can 'Call' from a Public Function that will clear all boxes from any form that I would like to clear, on any given form.
Kind regards,
Neil.