Prompt box question

[csdrex87]

Ok quick question. I have looked up on the internet and found nothing about it but is there a way in a prompt box using VBA code to set a drop down menu instead of a string field input?

 

[SOS]

Nope, you would have to create your own form for that.

 

[csdrex87]

I had never thought of that but thats an ingenious idea. lol off to make a form and have it do a do open command

 

[SOS]

I had never thought of that but thats an ingenious idea. lol off to make a form and have it do a do open command

And if you open it as acDialog then it will stay on top and nothing else will happen until you close it. So you can have your YES / NO (or other custom buttons, etc. and then resume code based on the selection.

 

[csdrex87]

I actually just set the settings to modal on and got rid of the close box and menubar