Msgbox Input on Form Load

[Luchino]

Hi all,



I have an order form, with fields "Date", "Type" and "Account".

I would like that, upon opening the form, the user is prompted with a dialog/message box asking for the input for these three fields, which will then populate the new order form. I would also like that there be a drop-down box to choose the value of "Type", the options being: "Order", "Quotation" and "Invoice".
How do I go about this? I already have this:

Dim myValue As Variant
myValue = InputBox("Enter Date")
Date.Value = myValue

But I can only do this for one value at a time. How can I get one message box with all three fields, including the dropdown box for "Type"?

Thanks in advance!

[RuralGuy]

How about creating another form that asks these questions and then when properly completed, pass then to your "Order Form" in the OpenArgs argument? With another form you can completely validate the input including using ComboBoxes for selections to eliminate typos.

[CJ_London]

Date and Type are reserved words, using them as field names can cause errors difficult to resolve. Strongly recommend you change them to something more meaningful like orderdate, ordertype

here is a link to reserved words https://support.office.com/en-us/art...7-da237c63eabe