changing form field source?

E

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
 
A

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
 
E

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
 
Top