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
.