Continuous subform has an unbound control that I can't get to wor

[magicdds-]

I have a form with a continuous subform. The form is based on a products table.
The subform is based on a table listing who is paying for the products. A
third table lists how much each person is paying towards the product. There
is a DLookUp function on a field in the subform, next to the person's name,
which looks up in table #3, how much each person will pay. I put an unbound
text box next to the amount text box, so the user can type in a different
amount that the person will pay if they change their mind. I want to use this
number to later go into table #3 and change the amount. But if you type a
number in an unbound text box in record#1, that number appears in all the
records, in that text box.

How can I type in a number in record #1, and a different number in record#2,
etc.

Thanks,
Mark

 

[banem2]

I have a form with a continuous subform. The form is based on a products table.
The subform is based on a table listing who is paying for the products. A
third table lists how much each person is paying towards the product. There
is a DLookUp function on a field in the subform, next to the person's name,
which looks up in table #3, how much each person will pay. I put an unbound
text box next to the amount text box, so the user can type in a different
amount that the person will pay if they change their mind. I want to use this
number to later go into table #3 and change the amount. But if you type a
number in an unbound text box in record#1, that number appears in all the
records, in that text box.

How can I type in a number in record #1, and a different number in record#2,
etc.

Thanks,
Mark

Hello,

One solution is to add new field into #3 table to hold temporary data.

Regards,
Branislav Mihaljev, Microsoft Access MVP