How can I clear the control Source property by code?

[Guest]

Does anyone know how to set the property? thanks

 

[Arvin Meyer]

Does anyone know how to set the property? thanks

Me.txtFoo.ControlSource = variable

The variable must be a field in the underlying table or query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Sorry .. I mean is the record source for a form.

 

[Arvin Meyer]

Sorry .. I mean is the record source for a form.

Easier (aircode):

Sub Form_Open()
Me.Recordsource = ""
End Sub

Put a SQL string or table or query name between the quote to change the
recordsource.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks so much Arvin. I have been guessing what it should be for several hours. I put space between the two quotes and that's why it did not work.