Yeah, it's declared in a general declaring module of mine and I need it to test if the user has selected more than 1 record for deleting.
The user should ONLY select 1 record because of the handling of the related file on the disk.
The more I look at the code the less I understand the use of that global variable. SelHeight tells how many records are selected. Why do you need a variable? I don't see how that variable really accomplishes anything, especially since you only want to allow deletion of 1 record. I have code that allows user to select and delete multiple records and do have a public variable that keeps count of records as code cycles to delete each.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Maybe I can do some changes there ... but I'm sure it has NO effects at all on the original problem ;-))
but I'll look into that too now that I have to do some analyzing of that code.
I tryed inserting this:
DoCmd.RunSQL "DELETE FROM PERS_SOCHÆN WHERE PERS_SOCHÆN.SocHID =" & SocHID
in the form-delete event and it does what I want it to do BUT ...
1) all my handling of related Word-files is NOT done
2) the proces is NOT completed because of multiuserproblems (Error 3197)
HELPPPPPPPPPPPPP !