Problem with continuous subform.

[wrek]

I have a problem manipulating data in a subform. I couldn't think of a better way to describe it than to put it in graphics:

http://angelfire.com/pw/access/nformproblem.doc

Would appreciate any help....Thanks.

 

[Atomic Shrimp]

If I read it right, you want an empty field in a continuous form that you can populate with values relevant to each particular row, doing this with an unbound text box doesn't work because any value entered will show against all rows.

Right?

If so, I think the way to do it is create a blank field in the source table, then the text box doesn't have to be unbound.

 

[wrek]

Yep, that's exactly my problem and yours is a good suggestion but....

...the reason I can't edit the source tables is that the entire company (4000+ strong) uses them. And they are live tables, updated often daily...so I couldn't use a static version of it either.

Any other ideas?