Trouble clearing records on a form

[NightWalker]

I am trying to write code in a subform to clear all textboxes and checkboxes on a form before they are written to the table. My subform has all the navigation buttons for multiple forms. I want to make a clear record button for if someone makes a mistake while filling in the data. I am wanting the clear button to work on the multiple forms. I was thinking of using the control tags but i dont know how to clear checkboxes using the control tags. The forms have different amounts of textboxes and checkboxes. What would be the best way to accomplish what i am trying to do? Thank you in advance. --Walker

[pbaldy]

After you've checked the tag property you can use Select/Case on the ControlType of the current control, and do something different (set to 0) for combos.

[CJ_London]

not at all clear to me why you would want to do this but if you want one bit of code to work for every form then something like this function placed in a general module might do what you want

function formCleared(frm as form) as boolean
dim ctl as control

on error goto errctrl

    for each ctl in frm.controls
        if ctl.controltype =acTextBox then ctl=null
    next ctl

    formCleared=true
    exit function

errctrl:
   msgbox "err & ": " & err.description & " in " & frm.name
   formCleared=false

end function

you would call it from a form with something like

if formCleared(me) then donextthing

[NightWalker]

I am wanting to make a one click way for the user to clear the data they put into the form. At current time the multiple forms are bound forms. Maybe this would be a better question. Is it best practice to make a recordset with an unbound form for data entry forms? If my thinking here is correct then i could just clear the recordset before the submit/save button was clicked. Would this be a better approach?

[CJ_London]

why not just set the form data entry property to yes?

[pbaldy]

Is it best practice to make a recordset with an unbound form for data entry forms? If my thinking here is correct then i could just clear the recordset before the submit/save button was clicked. Would this be a better approach?

As to this, while I'm not above using an unbound form, probably 95% of the forms I've built are bound. I think the prevailing opinion is that it's easiest to let Access do the heavy lifting.