ColumnHistory syntax

[Alain]

Hi to all,

I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.

Before I go insane , can anyone let me know what is the problem

Thanks

 

[Alain]

Forgot to mention that I want to build a popup report and assign the right
control source to only 1 textbox instead of building approx 20 different
report. It is working just fine now if I assign it directly to the control
source but I want to code it at the open report event.

 

[Marshall Barton]

I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.

Your control source expression needs an = sign and must be a
string:

me.text1.ControlSource =
"=ColumnHistory(""tblActionPlanned"",
""OtherFutCancNotices"", ""IdBranch = 1"")"

 

[Alain]

Thanks for the info

I am trying to use the ColumnHistory method but every time I alwasy get the
error 3075 syntax error ( missing operator ) in query .......

I have tried many different way to get the information but no luck;
ex1: me.text1.ControlSource = ColumnHistory("tblActionPlanned",
"OtherFutCancNotices", "IdBranch = 1")

ex2:me.text1.ControlSource = ColumnHistory([tblActionPlanned],
"OtherFutCancNotices", "IdBranch = 1")

ex3; me.text1.ControlSource =
me.Application.ColumnHistory([tblActionPlanned], "OtherFutCancNotices",
"IdBranch = 1")

I also tried the same syntax directly in the control source property of the
control and getting the same error.

Your control source expression needs an = sign and must be a
string:

me.text1.ControlSource =
"=ColumnHistory(""tblActionPlanned"",
""OtherFutCancNotices"", ""IdBranch = 1"")"