If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Continuous subform has an unbound control that I can't get to wor
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 |
#2
|
|||
|
|||
Continuous subform has an unbound control that I can't get to wor
On Apr 21, 5:29*am, magicdds-
wrote: 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 |
Thread Tools | |
Display Modes | |
|
|