By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Command Button changing Textbox ControlSource

P: 7
I want to change the controlsource of a textbox when i click a command button but everytime i do so it gives me #Name$ in the text boxt

this is what i want to control source to be

Combo2.ControlSource = DCount("name", "table")
Jun 6 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
I want to change the controlsource of a textbox when i click a command button but everytime i do so it gives me #Name$ in the text boxt

this is what i want to control source to be

Combo2.ControlSource = DCount("name", "table")
Assuming you want to display the Count number in the textbox try

Combo2.ControlSource = "=" & DCount("name", "table")


MTB
Jun 6 '07 #2

P: 7
Assuming you want to display the Count number in the textbox try

Combo2.ControlSource = "=" & DCount("name", "table")


MTB
WOW thank you so much worked like a charm i owe u one!
Jun 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.