Changing the Control Source

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

Hi, I have a main form called "Financials Main Form", which contains a
subform called "Assets Subform". The main form has a textbox called "Last
Year" to be used as an input from the user. The subform is referenced to a
query called "Assets", whose SQL is changed according to the input from the
textbox "Last Year".

The ControlSource property of the contrlos contained in the subform must
match the fields of the query. That is, if one control has its ControlSource
property set to "Last Year -1", then the query must have a field called "Last
Year -1".

The problem is that the SQL of the query changes successfully, but the
ControlSource property of the controls doesn't. Let TxtBox be one of the
controls. I am using the following statement:

TxtBox.ControlSource = "Last Year " & x,

where x is the value of the text box "Last Year".

Can someone explain me how should I change the ControlSource property of the
controls while the main form is running?
 
Carlos said:
Hi, I have a main form called "Financials Main Form", which contains a
subform called "Assets Subform". The main form has a textbox called "Last
Year" to be used as an input from the user. The subform is referenced to a
query called "Assets", whose SQL is changed according to the input from the
textbox "Last Year".

The ControlSource property of the contrlos contained in the subform must
match the fields of the query. That is, if one control has its ControlSource
property set to "Last Year -1", then the query must have a field called "Last
Year -1".

The problem is that the SQL of the query changes successfully, but the
ControlSource property of the controls doesn't. Let TxtBox be one of the
controls. I am using the following statement:

TxtBox.ControlSource = "Last Year " & x,

where x is the value of the text box "Last Year".

Can someone explain me how should I change the ControlSource property of the
controls while the main form is running?
Click to expand...


A control source expression must be preceeded by an = sign.
try changing your code to:

Me.TxtBox.ControlSource = "=Last Year - " & Me.[Last Year]
 
Hi Marshall: unfortunately using the "=" sign didn't work. There must be
something wrong besides this. Thanks a lot anyway!
--
Carlos


Marshall Barton said:
Carlos said:
Hi, I have a main form called "Financials Main Form", which contains a
subform called "Assets Subform". The main form has a textbox called "Last
Year" to be used as an input from the user. The subform is referenced to a
query called "Assets", whose SQL is changed according to the input from the
textbox "Last Year".

The ControlSource property of the contrlos contained in the subform must
match the fields of the query. That is, if one control has its ControlSource
property set to "Last Year -1", then the query must have a field called "Last
Year -1".

The problem is that the SQL of the query changes successfully, but the
ControlSource property of the controls doesn't. Let TxtBox be one of the
controls. I am using the following statement:

TxtBox.ControlSource = "Last Year " & x,

where x is the value of the text box "Last Year".

Can someone explain me how should I change the ControlSource property of the
controls while the main form is running?
Click to expand...


A control source expression must be preceeded by an = sign.
try changing your code to:

Me.TxtBox.ControlSource = "=Last Year - " & Me.[Last Year]
Click to expand...
 
Carlos said:
Hi Marshall: unfortunately using the "=" sign didn't work. There must be
something wrong besides this. Thanks a lot anyway!
Click to expand...


What, exactly, did you use and what did it do? If there's
an error of some kind, post the error message.
 
Marshall: The problem was that there were severe inconsistencies between my
SQL and the subform. For instance, at all times the names of the textboxes in
the subform must match the names of the fields in the query. While modifying
the SQL I was changing the names of the fields in the query, but didn't
notice. That's why changing the ControlSource was useless.

Thanks a lot for your interest!
 
Back
Top