Changing a controlsource

tpowers · Jun 18, 2003

I am tring to change the controlsource for a control using vb but it is not working.

The code that I am using is as follows:

CountOfLoanNo.ControlSource = CountOfLoanNo

I keep getting a this error in the control box during run time. #name.

Why is this, and how can I fix it.

Thank you in advance,

TPowers

FYI.....

I am using Access 2000

TonyJollans · Jun 18, 2003

Hi TPowers,

Just off the top of my head, the ControlSource property wants a column name and so it should be ...

Code:

CountOfLoanNo.ControlSource =

Code:

&quot;

Code:

CountOfLoanNo

Code:

&quot;

Code:

But where are you putting this code? The Control name (CountOfLoanNo at the beginning of the statement) ought to be qualified (

Code:

Me!

Code:

CountOfLoanNo

perhaps).

Enjoy,
Tony

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Changing a controlsource

tpowers

Technical User

TonyJollans

Programmer

Similar threads

Part and Inventory Search

Sponsor