Problem pausing execution

[shay]

Hi

I've not used Access for a while and need some help...

I'm writing code to import data from an Excel spreadsheet. The data will not necessarily be in the correct units, so the plan is to import the data to a temporary table, display all the determinands which are in the wrong units and give the user the chance to insert the conversion factor, then do the sums where required and finally copy the modified data to the input tables.

However, I get as far as displaying the determinands which need a conversion factor but the execution of the code continues to the end of the module ie the whole thing is over before the conversion factors are even entered!

I need to be able to halt execution until the form on which the user enters the conversion factors is closed.

Any ideas? TIA.

shay

 

[Mile-O]

Open the form as a Dialog form.

 

[namliam]

just make the import run to the form 1 run

Then use a second bit of code under the close button of the form or something to finish the importing

 

[ColinEssex]

another alternative is to use this sleep module

http://www.mvps.org/access/api/api0021.htm

Col

 

[shay]

Many thanks for the replies. Opening the form in Dialog mode is the simplest solution I think. I did once know this but months away from Access has resulted in it a memory lapse!!

Regards

shay