[AccessD] Still having a subform problem...

Hi Christopher

> frmMain, which has a subform control named sFrm. sFrm's SourceObject
> = "frmSearch"

> frmSearch, which has a button named cmdSearch and a subform control
> named sFrmResults. sFrmResults' SourceObject = "frmResults".

> frmResults, which has a bunch of fields like FirstName, LastName,
> etc. Typical customer database stuff. frmResults displays as a
> datasheet.

> The Problem:

> In the code behind cmdSearch, there is a line that tries to re-order
> the columns in the datasheet contained in sFrmResults. That code
> looks like this:

> [sFrmResults].Form(sSearchField).ColumnOrder = 1

How about

  Me!sFrmResults.Form!sSearchField.ColumnOrder = 1

/gustav