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