changing form field source?

[Eric]

I have a text field on a form that's connected to a query source field.
However I'd like to sometimes connect it to another field instead. Is that
possible?

/e

 

[Arvin Meyer [MVP]]

To change the control's controlsource property, open the form in Design
View. Open the property sheet (double-click on the text box or open it from
the tool bar or View menu) Go to the Data tab and click in the controlsource
property. Using the down arrow, select the field you want.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Joseph Meehan]

To change the control's controlsource property, open the form in
Design View. Open the property sheet (double-click on the text box or
open it from the tool bar or View menu) Go to the Data tab and click
in the controlsource property. Using the down arrow, select the field
you want.

Or consider putting both fields in or maybe a trigger to switch the
source.

 

[Eric]

sry, I meant during runtime, ie what I want to do is to check if the field
is empty, if that is the case I want to switch to the other controlsource.

/e

 

[Garret]

If [Fieldname] = "" then
Me.controlsource = "Tablename"
end if

 

[Van T. Dinh]

Me.MyTextBox.ControlSource = "OtherFieldName"