Clearing all fields in an application form,reset for next customer.
I can clear all the text boxes when i press reset button ,ie txtName.text = "".... i can clear the combo boxes in the same way,but how do i reset the radiobuttons and checkboxes that have been selected.
Re: Clearing all fields in an application form,reset for next customer.
option1.value = False
check1 = vbUnchecked
Re: Clearing all fields in an application form,reset for next customer.
Quote:
Originally Posted by
d.paulson
option1.value = False
check1 = vbUnchecked
Thanks dude,i was wondering if you could clarify your answer for me,i'm a total novice here.
Much thanks anyway :)
Re: Clearing all fields in an application form,reset for next customer.
To clear or turn off an Option button:
Option1.Value = False
To clear a CheckBox:
Check1 = vbUnChecked
Re: Clearing all fields in an application form,reset for next customer.
Typically I will write a little sub routine to reset the form.
This sub would contain code to clear textboxes, checkboxes, option buttons, combos and set any defaults that may need to be set.
I would call this when I load the form and at any time the values need to be reset during execution.