Michael R Mattys
michael.mattys at adelphia.net
Tue Sep 7 09:58:36 CDT 2004
----- Original Message -----
From: "Arthur Fuller"
> My form has controls whose names derive from the EoM() of a given date.
> That is, the end of a month. The control's name will be something such
> as "12/31/2004", etc. I need to set the focus to the column
> corresponding to today's date. For the date on which I am writing this
> message, the correct column is named "9/30/2004".
...
> The EoM() function (which I wrote) returns a date. I need to take this
> value and turn it into a reference to a column, such that I can write:
>
> Me.columnName.SetFocus
Arthur,
It looks like you mean to say that you have
a subform set to "continuous forms." If that's
the case, you'd say
Me.SubformName.Form.Controls("EOMDate").SetFocus
----
Michael R. Mattys
Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com