bind data access page textbox controlsource property at run time Christian Bahnsen 10/23/2008 11:46:01 PM Is it possible to bind a data access page textbox controlsource property at run time? I've tried using the BeforeInitialBind event to set the controlsource for textboxes, using syntax like txtTwelfthMonth.ControlSource = temp but I get the Internet Explorer Script Error -- Object doesn’t support this property or method: ‘temp.ControlSource’ I'm trying to use this for data access pages based on crosstab queries where the data source is a rolling 12 month, so every month the periods change, e.g., 2008-02, 2008-03, etc. -- Christian Bahnsen

RE: bind data access page textbox controlsource property at run time Clifford Bass 11/11/2008 10:34:01 PM Hi Christian, In case you never figured it out, ControlSource is a string. So you would specify the name of the column as a string. txtTwelfthMonth.ControlSource = "SomeColumnInFormsRecordSource" Clifford Bass "Christian Bahnsen" wrote: [Quoted Text] > Is it possible to bind a data access page textbox controlsource property at > run time? > > I've tried using the BeforeInitialBind event to set the controlsource for > textboxes, using syntax like > > txtTwelfthMonth.ControlSource = temp > > but I get the > > Internet Explorer Script Error -- Object doesn’t support this property or > method: ‘temp.ControlSource’ > > I'm trying to use this for data access pages based on crosstab queries where > the data source is a rolling 12 month, so every month the periods change, > e.g., 2008-02, 2008-03, etc. > -- > Christian Bahnsen