Forms, Repeat, unbound text box, after update, records

[kplatt]

Hi, I have a problem.

I currently have a form based on a table where when i put data through a combo box in one [cell], it auto populates an unbound text box [cell2]. I have the autoupdate completed through an after update event and it is working. But the problem is all the records in the form show the same data in Cell2 when static but when i change or move to the next record [Cell] it changes all of the [cell2] data again, repeating that associated data with the Current [Cell] that the cursor is on...and so on. I think the form is accepting each field from the table as its own record but when it comes to the updated unbound text boxes, it repeats. this basically becomes a view problem. is there any way to avoid this. Do I need to put the auto update into a query or can i use a "multiple items form" to avoid this issue?

Thanks

 

[boblarson]

Unbound controls on a datasheet or continuous form will show one value for all records. When you have a control on a datasheet or continuous form, it really doesn't exist except for the record you are on. All others just are a mirror of it. It is the same for bound controls too, but with the recordset Access knows to use the values for the different records to display, but with an unbound text box there is no set of records to use, just the single value. So, when you assign a value, it is the value of all of the "clones" of the control.

I hope that helps, but I know it can be a pain and it sometimes requires putting in another field and bind it to that just to handle it.

 

[kplatt]

So you are saying to use a bound text box? thanks

 

[boblarson]

So you are saying to use a bound text box? thanks

Yes, that would be necessary if you have to have different values showing for each record.