control source

[maxmangion]

is it possible to change the control source of an unbound text box ?

For example i have a textbox which simply displays the number of current records displayed i.e. =DCount("*", "queryname")

Now i wanted that with the click of a button (or something), i wanted to change it's controlsource to =DCount("*", "queryname2") ... however, as a result i got #name instead of the correct count.

Thanks

 

[KeithIT]

Can you post the code you are using to have it change the source?

Is it possible that you simply have a spelling error in the name of the new control? I know this sounds stupid, but I've spent days trying to fix lines of code in databases only to find out that the problem was a stupid spelling error in my code (very frustrating after hours of reprogramming work).

 

[Mile-O]

Yes, you can change the controlsource.

Just remember to bulk up on the " because you are assigning a string.

Me.MyControl.ControlSource = "=DCount("""*""", """queryname2""")"

 

[maxmangion]

thank you the " was the problem ... actually, with reference to my other thread, following your suggestion of using the querydef, i do not think that i will be using this now, but it is good to know it, for future reference

Thank You

 

[maxmangion]

Just to let you know that with """*""", """queryname""" i got a syntax error message, however with just 2 i.e. ""*"", ""queryname"" it worked fine.

Thanks

 

[Mile-O]

I got over-eager with the "