J
Jeff
Does anyone know how to set the property? thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
Jeff said: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
J
Jeff
Sorry .. I mean is the record source for a form.
A
Arvin Meyer
Jeff said: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
J
Jeff
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.