Hi,

I have a module that opens a form if a given circumstance is true. I need to be able to pause the code and open the form to get the user input. Then I want the code to continue running after the user exits that form. Is there a way to do this?

Thanks for any help!

Dave

An intermediate form or InputBox. The intermediate for should be Modal to prevent any other action in the database until it is submitted.

Did that help?

mmcdonal

I've set the Modal property to Yes in the form's property box, but its still not working for me. Is there something else I need to do?

You need to write the code so that if the condition is true, the code exits, and it continued on the form OR, use an inputbox to get the information.

Example:

sFName = "Mike"

If sName = "Mike" Then
   sLName = InputBox "Please enter your last name"
End If

This check for the condition, and throws an input box for further data gathering.

Look up InputBox on MSDN.

Did that help?

If you need to get more data, you can throw up more input boxes, but that is problematic.

The alternative is to send out the form and exiting the sub, but you will need public variables for this, which is also not a problem.

If this doesn't work, you need to post the steps, code and business rules you want to use.

mmcdonal

OK. I'm trying to switch over to input boxes for this. Is there a way to have multiple textboxes on an input box? Ideally I would need 2 input boxes with 4 textboxes each. If this isn't possible then I will have to have 8 input boxes, which seems like it might be a little confusing for the end user.

Thanks,
Dave

You want to use a modal form and some public variables, most likely.


mmcdonal