Once again, works perfectly! Thanks, Dude.

Now, how easy would it be to add another button that would mailmerg
all the records and print a sheet of address labels?

I'm thinking that that's pretty advanced stuff?

dude Wrote:
keeping things simple, you could:

add an if test like:
If na < 1 or na < 3 Then
Controls(na) =""
End if
in your For next loop to exclude the combo / textboxes you
want to keep the values from being deleted
or
you could after the For loop just place the data back in eg

Textbox1.Text = date

Hope helps


--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=26092

a little more involved & would really need to understand
the result you are looking for. Short of writing the whole
thing for you - I suggest have a play yourself & if it
does not work / give required result - post here for
further help.

-----Original Message-----

Once again, works perfectly! Thanks, Dude.

Now, how easy would it be to add another button that
would mailmerge
all the records and print a sheet of address labels?

I'm thinking that that's pretty advanced stuff?

dude Wrote:
keeping things simple, you could:

add an if test like:
If na < 1 or na < 3 Then
Controls(na) =""
End if
in your For next loop to exclude the combo / textboxes
you
want to keep the values from being deleted
or
you could after the For loop just place the data back
in eg

Textbox1.Text = date

Hope helps



--
madbloke
----------------------------------------------------------
--------------
madbloke's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14422
View this thread:
http://www.excelforum.com/showthread...hreadid=260925

.