[AccessD] Link To Code Gets Deleted

Rocky,

    Design interference is the most likely factor, as pointed out by Charlotte. Occasionally, there could be a freeze of start up form when trying to open a db developed in access 2003, in access 2000, even though the file format is as per access 2000.

    As a work-around, you can consider putting code in form's load event, in following style (CmdTest is the name of command button in question):

Private Sub Form_Load()
    Me.CmdTest.OnClick = "[Event Procedure]"
End Sub

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Charlotte Foust 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, March 28, 2007 06:06
  Subject: Re: [AccessD] Link To Code Gets Deleted


  Are they able to do any manipulation of the design?  That commonly
  happens when you cut a control and paste it to another section of the
  form.

  Charlotte Foust 

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
  at Beach Access Software
  Sent: Tuesday, March 27, 2007 11:20 AM
  To: 'Access Developers discussion and problem solving'
  Subject: [AccessD] Link To Code Gets Deleted

  Dear List:
   
  I have event procedures in places like Click or After Update and from
  time to time a user reports that a function has stopped working.  When I look at the property sheet for the control in question, I find that the
  [Event Procedure] in the event is missing.  If I replace it, and click
  the builder button, the code page opens up and there it is all fine and
  everything works again.
   
  Is anyone else having this problem or experienced it?  

  MTIA,
   
  Rocky