[AccessD] Syntax question about control references

Hi. No it is not set to continuous forms. (Frankly, except for very
limited situations, I HATE continuous forms, but that's another story.)
It's set for datasheet view. It's easy enough to set the focus to the
desired control, but that's only half what I need. I need to scroll the
form such that the control with focus is in the first unfrozen position.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R
Mattys
Sent: Tuesday, September 07, 2004 10:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Syntax question about control references



----- 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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com