code for clear button is not working

**tommyried** · 03-12-2014, 07:12 AM

Hello everyone ,

Please can anyone help me in the attached database,I want to clear the fields thru command button called clear iam getting an error in vba ?

**ItsMe** · 03-12-2014, 09:13 AM

Do not try to assign a value to your control that holds the expression. Assign null to the two will suffice.

Me.Text22 = Null
Me.Text24 = Null

**June7** · 03-12-2014, 11:18 AM

Why are there two bound textboxes each for discount and grossmargin? Why do you want to clear data from the record? Why do you need a calculate button? The expression will calculate automatically.

**tommyried** · 03-13-2014, 02:50 AM

thanks everyone

code for clear button is not working

Thread Tools

code for clear button is not working

Similar Threads

Button to clear a record, not working

clear fields button not working

Clear button on a search form partially working

Need Code and or directions to use command button to clear 2 fields

Command button code to clear form

Posting Permissions