Running a form to get user input when updating record

tofay

can somebody tell me how to run a form to get user input from a code (at runtime) that updates a record in the database table.

kriki

It is not exactly clear what you want to do. Can you explain a little more detailed?

kine

In general - first collect the inputs, than modify the records. Never collect inputs during modifying the records...

tofay

I place some button on a form that represent different stock items, I want this buttons when Clicked at (runtime) to display a second form that gets quantity from the user and inserts a record into a table with the item Clicked and the quantity entered by the user.

So my problem is how to run the second form that get quantity from the user and return the quantity entered by the user to the running code that insert the complete record after the item button is clicked.