Text box issue

[brucle]

I think I have missed something very simple, but I am having a senior moment.

It am trying to create an invoicing form. I have a table that lists items and prices.

I would like to create a form the lists these items and prices but allows the user to input the quantity ( default value of 0). This quantity is used for a calculated control to indicate the cost. I have all this built but I ran into a snag when the user changes the value of any one of the quantity boxes. ALL the quantity boxes are changed to that value. The calculated control then proceeds to do its thing as expected.

How do I allow the user to change the value of the quantity?

I have tried binding the form to the items and prices table. The form is set to allow edits.

Any suggestions would be greatly appreciated.

 

[missinglinq]

...when the user changes the value of any one of the quantity boxes. ALL the quantity boxes are changed to that value.

This behavior is normal for Unbound controls, which would seem to indicate that the Quantity textbox is not bound to a field in the underlying table.

 

[brucle]

Solved my own problem. I added a QTY field to the prices table and bound the control to the field. I added some code to the on open event that updates the quantities to zero to "reset" the form.