Subform Data Entry Issue

[yuriyl]

I have a subform that displays results from a query based on what was selected from the drop down box in the parent form. In this subform I'm also including a text box that is not tied to query so that the user can enter some values next to each record returned. Well if the user enters something for one record the text boxes get filled in with the same value for all the other records. I hope this makes sense I'm attaching a doc with a picture of what this looks like. Once the Sub Process is selected the sub form below brings back SPEC ID, DESC AND VALUE and the DEDUCTION and OPPORTUNITY are the two text boxes that are not tied to the query and I want the user to be able to enter data in those. Once the user enters data in the VALUE box on one record there rest of the VALUE text boxes get populated with the same data. Maybe I need to use a special control for this? Thanks in advance for any assistance.

[RuralGuy]

You are describing the action of an unbound control on a continuous form. The only way to make those TextBoxes display something different is to bind then to a field in the RecordSource, sorry. That is just the way it works.

[yuriyl]

Thanks RuralGuy, I might just get rid of the subform create couple of hidden text boxes and arrange them to have a grid like look and then dynamically add data to them and make them visible.

[RuralGuy]

Any solution that works is a good one.