Setting all Searchfields in a Form to Default value

[Bongobob21]

Hi,

I want to insert a delte button into my Form to set all fields on the form totheir feault value. As i have many forms and many searchfields in them, I wanted to know if there is a command setting all sarchfields of a form it their default value. Otherwise it would be a lot of work to reste all fields one by one.



Thanks in advance

[CJ_London]

depends how your form is set up, but you can loop through each control to reset

Easiest way is probably to use the control tag property to indicate which are search fields - e.g. for those controls you want to reset put say 'searchfield' (no quotes) in the tab property

then for the code behind your reset button put

dim ctrl as control
for each ctrl in me.controls
    if ctrl.tag="searchfield" then ctrl.value=""
next ctrl