I have an application that has a form which is doing 90% of what I need. Basically, it's form/report that shows orders taken (think shopping cart). When the order is ready to ship, I have my user edit the record, update a comments field, and mark the order closed by changing a status. Then they Submit and they're done.

I created a button on the report for closing the order by just changing the status, so that's working fine. But I can't have the button prompt for user input.

What I'd LIKE to do is -- when that button is pushed -- have a message box open up, ask for the comments, add them to the record, and then continue as per normal with changing the status to closed. This type of behavior would be similar to a MessageBox or InputBox in other languages. The idea is that once the user clicks the button, I want them to be prompted to enter their comments, and then process the rest of the action for them.

Any ideas on how to do this? I'm proficient in Deluge, but haven't done anything super complex yet. I know there are no controls for accepting input, so I'm thinking this would have to be done via a form (to accept the input) and then update the record in the other table, and finally delete the row from the temporary form. Or something of that sort??

How would you implement something like this?

THANKS!
Bruce