To make your program pause for user input, you need to build a small form to accept the user input. This form must be opened using the acDialog arugument of the DoCmd.OpenForm method.
DoCmd.OpenForm "YourFormName", , , , , acDialog
Using the acDialog arugment as shown above, in conjunction with your code will cause your code to pause until the form is closed. The code will then resume from that point.
HTH X-)
RDH
Ricky Hicks
rdhicks@mindspring.com