It is likely that the code does not recognize "frmaddrecord" as a Userform.
Just what does frmaddrecord refer to?
--
steveB

Remove "AYN" from email to respond
"robhargreaves"
wrote in message
news:robhargreaves.1soiyc_1122217504.529@excelforu m-nospam.com...

I have just finshed my workbook and I am pleased with it other than one
or two issues but following a code or sheet change I cannot work out
why a form doesnt work.

Excel is giving me an error -

Run time 1004

Application defined or object defined error

When I de bug it shows me module 1 and the code highlighted saying

frmaddrecord.show

This doesnt help me much at identifying where the problem is.

I have searched the internet and a few posts mention a reference been
wrong or it being an issue with personal.xls.

They are getting it when they are opening the workbook mine is just
when opening the add records button to the form to add records from the
menu.

I have attached my workbook to this post if anyone can have a look for
me that would be great.

Thanks

Rob


+-------------------------------------------------------------------+
|Filename: excelproject.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3620 |
+-------------------------------------------------------------------+

--
robhargreaves
------------------------------------------------------------------------
robhargreaves's Profile:
http://www.excelforum.com/member.php...o&userid=25519
View this thread: http://www.excelforum.com/showthread...hreadid=389714