Sel Functions in a query based subform
Posted on 2004-03-22
I have a 3 tab form. In the first two pages the sourceobject of the subforms is a table. In the last page, the sourceobject of the subform is a query. I can determine the size and location of a selected/highlighted area on the first two pages with:
forms!fmName!sfmPage1.form.selleft or seltop,selheight, or selwidth - this works fine. Of course I switch between sfmPage1 and sfmPage2.
When I select page 3 of the form and use the same code, I get a runtime error 2455. Incorrect reference to SelHeight.
I have been chasing this one for over a month. Can anyone tell me how to programatically determine the location and size of a highlighted area on a query which is the sourceobject of a subform? I am using Access 2000 under XP Home. The query is a crosstab and therefore cannot be updated.