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

Syntax error in Access VBA. Trying to change the source property thru VBA

P: 4
Below is a line of code that should work but doesn't.
I am trying to change the code via access VBA.

[code] Me!WapvWk1_txtbx.ControlSource = "=DLookup("[SumOfAnn_Prem]", "BBDK_WBus_New_2019_Wk1_Query")"

Not sure what is wrong. I have tried to find the answers many times in many places.

Please Help and I thank you in advance.
Jan 8 '19 #1
Share this Question
Share on Google+
1 Reply

P: 4
Please forgive me for answering my own ?
Here goes.
Me!WapvWk1_txtbx.ControlSource = "=DLookup(""[SumOfAnn_Prem]"", ""BBDK_WBus_New_2019_Wk1_Query"")"
Requires two sets of Quotes "" like this to correct the problem .
But have no idea WHY... that's my only ?

Jan 8 '19 #2

Post your reply

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