CODEWITHSUNDEEP
ms-accessvbams-access-2003
Ish
Ish

Reputation: 671

Bind Textbox To a Field

I have a form in MS access. I have created a few textboxs in that form. I have input a function in the control source property of a particular textbox(TOTAL). This basically sums up numbers entered by the user and displays it in the textbox.

The problem is the textbox is unbound. I want to bind the textbox to a field in the table using vba code. I could have just bind the textbox by the putting the table field name in the control source property but it is occupied with the SUM() function.

I not sure how to proceed here. I have tried searching up on the web for several days but failed to gather a reasonale solution.

Please help

Upvotes: 0

Views: 2411

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

You need to remove the sum function and put that in a suitable event for the form or event for another control and then bind the textbox.

As a general rule, you should not be storing calculated values, it is against the rules for normalization.

Upvotes: 1

Related Questions