Use Form As An Input Box

[jo15765]

I have a form that I am unable to modify the form, but can alter/change VBA - and it has a button that when pressed runs a few update/insert statements and dumps data into Excel. I am in need of a way, and I know an input box can do this, but can you use 1 input box for multiple input, to get 3 inputs from the user before the make table/inserts are performed. I know an input box can capture 1 value at a time and what is most important is code execution freezes, which is what I need.

Is there a way to on the button press, launch a form with 3 labels, 3 text boxes and 2 buttons (cancel, and ok) -> freeze code execution, if the cancel button is clicked break all code execution here, if the ok button is pressed, verifiy a valid entry was input into all 3 text boxes, if yes, then proceede with the code. If no, throw an error and force valid input into all text boxes before continuing.

[June7]

Freeze what code execution? The first form procedure that calls the second form? acDialog parameter will suspend code on the first form until the second form closes.

Yes, I do that. Example:

Private Sub btnSPG_Click()
DoCmd.OpenForm "BituminousMixToolsSPG", , , , , acDialog
Me.Refresh
End Sub

Code behind the second form will validate textboxes.

[jo15765]

What does the Me.Refresh do?

Sorry - the freeze code execution I was referencing was the insert and update statements. I ONLY want those to run IF all 3 text boxes have been populated AND the ok button was pressed.

[June7]

Me.Refresh is refreshing data on the first form because purpose of second form is to add/edit record.

As I said, code behind second form validates textboxes. Only run INSERT or UPDATE if conditions met. Code in button Click event. Use If Then Else structure.