How do I clear a form without a button

Hi Dave

Thanks for your help. A moment ago I added the following 2 lines of code
and it does what I want. Is this an ok way of doing it too or something
that would be frowned on by those who know better :-) I'm just learning as
you would probably have guessed.

Unload frmNewMember
frmNewMember.Show

cheers
Pam
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B38E01.A1260975@verizonXSPAM.net...
> Just add some more lines before the end of your sub:
>
> txtAddress.value = ""
> txtSuburb.value = ""
> ...
> cboThird.value = ""
>
>
> But sometimes users want to keep the values for the next entry.
>

I think I'd just reassign the values, but that's just me.

Pam Field wrote:
>
> Hi Dave
>
> Thanks for your help. A moment ago I added the following 2 lines of code
> and it does what I want. Is this an ok way of doing it too or something
> that would be frowned on by those who know better :-) I'm just learning as
> you would probably have guessed.
>
> Unload frmNewMember
> frmNewMember.Show
>
> cheers
> Pam
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44B38E01.A1260975@verizonXSPAM.net...
> > Just add some more lines before the end of your sub:
> >
> > txtAddress.value = ""
> > txtSuburb.value = ""
> > ...
> > cboThird.value = ""
> >
> >
> > But sometimes users want to keep the values for the next entry.
> >

--

Dave Peterson

OK Thanks again


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B39142.D7A8744E@verizonXSPAM.net...
>I think I'd just reassign the values, but that's just me.
>