Carrie,

Thanks for the flattery. Unfortunately, I don't use Forms that much.
I was able to record a macro that opened a form though. Same issues.
I had to hit Cancel before I could stop recording. I then assigned
that macro to a command button to run it. I ran into the same issue
where when the form popped up by clicking on the command button, the
user would have to click on New manually but it did not produce a
"different" form. My labels were as when I recorded the macro. Not
sure exactly what the issue might be. I am sure that someone in the
group must have some insight though. Hope you get the answer you
need.

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546