In my database I have a parent form which is a clients information and a subform (in table form) which contains all the notes on a file.  It links the two forms relationaly by the client #. I have been trying to add programming to the subform to have it automatically enter the client # a note ID # and the date, time and user into the note line and then the user can enter their note on the file.

I found that every time I entered certain fields it occasionaly crashed and the programming never really worked. To try and resolve this I commented out all the code and just had it perform a writeln on each subform event just so i could see the path the program takes when navigating through subforms in case there was a problem with the logic. I then tested the code by pulling up the subform as a form and it seemed to be working there.

The next step was to try and pull up the parent form and try it again. When it first pulled up the parent form it reported that the subform and performed the form entry and element entry events (which in my opinion doesn't make sense about the element entry event as I hadn't clicked on the subform yet). I then clicked into the subform and noticed no events were executed (which is what I want to happen). Sometimes clicking into the subform crashes it some times it doesn't. I did find that if I clicked on an element twice while in the subform it crashed every time.

Anyone have any ideas? At this point I'm not even trying to do anything just have it write a msg on each event and it still keeps crashing  .

Thanks

Justin

Quote:


I believe since you are relationally linked to the record in the subform as soon as a parent record is displayed the data that matches the link is searched and displayed on subform so actually it does enter (click on) the subform.

I found this to be a problem with using code to stop an f10 from adding blank record after blank record . I was able to use the code on the parent to control this but once I added same code to child databases every time it asked for the parent it then asked a similar question for each additional child subform.

I've received crashes when executing code from a subform too, even w/ simple writelns.  I discovered that the code w/in a subform executed before the code in the parent form, so some of my accesses to variables caused the crash(or so i'm led to believe).  What are you trying to do in the subform? Have you been able to auto-enter the client#?

Sometimes the automatic entry worked most of the time it did absolutely nothing - sometimes it crashed.

That code it wrote works well for retrieving the client number unfortunately it doesn't explain how to have it automatically fill out the records in the subform which is where I am having the problem.

That code is working perfectly fine its everything else about the subform isn't working