Unboubnd text box on tabular form

[aqif]

Hi

I have came accross to this silly problem and dont know how to get around it.

I have a tabular form Where I have Patient Information and the quantity of drugs they are using. I also have an Unbound text box where user enters a quantity and then press Add button and the quantity gets added. But whenever I enter quantity in First Row "Quantity Text box" and press enter all the text boxes in rows below automatically gets filled with the first quantity. It is creating quite a lot of confusion in minds of users. Is there any way to prevent the other text boxes to automaticaly populate themselves?

Any help will be appreciated


Cheers!
Aqif

 

[boblarson]

It sounds like the text boxes that are filling automatically are bound to the same field as the one you are updating when pressing your add button. If that is the case, then they are all just displaying the data which has been added to the table for the field where they are bound.

 

[aqif]

hope I am making sense this time

Hi

There is nothing wrong with my code of Add button and the Quantity text box is also unbound. What actually happening is that I have a tabular form and there is a add quantity text box which is unbound. Whenever I enter any quantity in the first record row unbound text box, the same quantity appears in the Unbound text box in all the other record rows too. If I am not making the just follow these two steps n u'll see most unusuall scenario.

1. Create a tabular form
2. Create an unbound text box in the detail section so that every record shows that text box.
3. Now enter any number in that unbound text box and press enter. You will see all rows filled with same value and this is the thing I want to prevent.

Hope I make sense

Cheers!
Aqif

 

[Rich]

Why not bind the textbox?

 

[boblarson]

Aqif:

If you have an unbound text box and you type something into it, of course it will continue to have that value until you tell it to set it back to 0, null, or empty string. It doesn't just do it on it's own. If you want it to clear, you would have to put code in at the end of your add button's code to clear the box.

Like:

Me.txtMyTextBoxName = ""


Got it?