Hello there fellow accessians,

I have a small access / application that I am creating.  I hav
migrated over to using the spreadsheet control to do the data entry (
like using excel, but want to keep my data in a database).  Anyway
have written some small scripts to read in and out the data from th
database (in and out of these spreadsheet controls owc10.spreadsheet).

I have also written a dataduplication routine, which spawns a no
editable spreadsheet control with any duplicated rows from a callin
spreadsheet control and allows the user to keep or discard these row
with two buttons.

I want all of this to happen when the user exits the data entry for
here is my envision sequence of events

spreadsheet_onEnter : load data from appropriate query / table

spreadsheet_onExit :

run duplicate row value check (possible spawn form for user input
if user specifies delete information out of spreadsheet

begin transaction
clear associated table
save information back into table
end transaction / if error occured roll back stop exit refresh form
apologize to user

exit form

The problem I am having is how to you pause an event to wait for a use
input.

I try using a while loop, but that sucked all the cpu up and the othe
form was usless because of the infinitely looping cycle.  

What I want is some wait to hold the exit event waiting for the othe
form to close...

If no other person has an idea i will slap a exit button in and tra
the other exit events and force the user to use the button to click ou
so I can cycle through a few more events and perhaps raise the exi
event on my own from the child form.  

Any help would be great

Thanks,
Geoffr

-----------------------------------------------
~~
~~