object defined error

[robhargreaves]

I have just finshed my workbook and I am pleased with it other than on
or two issues but following a code or sheet change I cannot work ou
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 bee
wrong or it being an issue with personal.xls.

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

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

Thanks

Ro

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

 

[Norman Jones]

Hi Rob,

Few in this group woulld be prepared to open such attachments, and very
properly so.

Try, instead, posting the contentious code with a brief description of the
background and any salient information.


---
Regards,
Norman



"robhargreaves" <[email protected]>
wrote in message
news:[email protected]...

 

[STEVE BELL]

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" <[email protected]>
wrote in message
news:[email protected]...