Text Box Issue

[adamtate94]

Hi, I have got a subform which has done data pulled in from a table, and the rest has text boxes for input. Whenever I put a value in one text box it changes the value for all of the other records. Show Below (attached), any ideas why?
Thanks In Advance

 

[sneuberg]

That would happen if the textboxes are unbound. Is that the case? In continuous forms unbound textboxes act like one textbox for all instances.

 

[adamtate94]

Thanks for the reply

They are unbound, im running an SQL INSERT using their values. Do they need to be bound?

 

[sneuberg]

Do they need to be bound?

Yes if you want to insert multiple records at once in a batch mode. You would need to use a table for this but this could be a bad idea especially if you have multiple users.

Is that what you are trying to do and if so why?

 

[smig]

I think the issue is not with the text box, but with your overall design.
What are you trying to do? please explain in simple English