msgbox q?

[yessir]

Can you put a dropdown in a msgbox?

i have the following:

I want the user to be able to select a value from a table when they Select NO to entering a new value.

the code is run off the commmand30 button at the top.

Currently it pops up a form with the msgbox, but it fails to wait for a response...

PLEASE HELP!
~

 

[SQL_Hell]

No, but you can do this with a pop up form.

 

[yessir]

No, but you can do this with a pop up form.

can you shed some light as to the example given in the first post (the included db?)

 

[SQL_Hell]

You shouldn't really need me to do it for you, just create a form that looks like a msg box and in the properties you set it to 'pop up form'.

then when the user clicks the command 30 button run a command to open the form.

 

[yessir]

You shouldn't really need me to do it for you, just create a form that looks like a msg box and in the properties you set it to 'pop up form'.

then when the user clicks the command 30 button run a command to open the form.

if you open the db and try that you'll see my problem.

 

[yessir]

The active control is the one with the focus and on the form with the combo, that control will ALWAYS be the button since your test is done in the click event of the button control! You need to reference the combo control to get the entered value.

The problem is in the ELSE statement AND the fact that it doesn't wait for a return form the other form!

There MUST be a way to do this.
BUT I AM STUMPED!

i really need help...

 

[yessir]

Start by fixing the code to reference the correct controls. If you want the code in frmA to stop and wait when you open frmB, you'll need to open frmB as a modal pop-up.

I have this already...
BUT it doesn't stop and wait...

Then frmA will resume when you close frmB

It either stops or finishes the work without waiting...

If you are using frmB to collect parameters for frmA, you will need to store them either in a global variable or in a hidden form that remains open throughout the session since when frmB closes, frmB's controls are no longer accessable.

That is why i make frmB invisible, pass the parameter, then close frmB...

I am including the db, try running the form import and you'll get a better understanding of what i mean and why i am asking for help...