Microsoft KB Archive/245136

= MOD2000: Workflow Toolbar Error Message When You Change the Record Source of a Data Access Page =

Article ID: 245136

Article Last Modified on 7/31/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q245136



SYMPTOMS
When you change the record source of a data access page to a record source other than the one previously specified by the Workflow Toolbar Control of the page, you may receive the following error message:

Microsoft Office Developer Workflow Toolbar

Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. Unable to bind to the workflow state field. Verify this field is present in the bound section of the Data Access Page.



CAUSE
The Workflow Toolbar Control binds to the first record source found on the page. Initially, the Workflow Toolbar Control binds to the record source of the page. However, each dropdown list or list box control added to a page has its own, unique record source. (You can see all the control record sources on the Page tab of the field list.) If you change the record source of the page, it changes the order of the other record sources listed on the Page tab of the field list. Whatever record source is first becomes the record source to which the Workflow Toolbar Control binds itself. Therefore, if you delete the control, the Workflow Toolbar Control still binds to the incorrect record source.



RESOLUTION
To work around this behavior, change the UniqueTable property of the page header (on the Data tab of the page header) back to the view name of the original data source (for example, IssuesView) and explicitly set the Workflow Toolbar Control RecordSource property, as demonstrated in the following steps:
 * 1) In Design view of the page, double-click the Workflow Toolbar Control to display the properties sheet.
 * 2) Click the first Data tab from the left.
 * 3) Set the RecordSource property to the proper source for this page. The Workflow Toolbar Control record source should be the same as the page record source (for example, dbo_ ).

Note that you must include the "dbo_" prefix for the table or view if you see the "dbo_" prefix. If you do not see the "dbo_" prefix for the table or view, do not specify the "dbo_" prefix.

To see a list of record sources for a page:
 * 1) On the View menu, click Field List.
 * 2) Click the Page tab. A list of record sources for the page is displayed.



Steps to Reproduce the Behavior

 * 1) In a database with workflow, create a data access page.
 * 2) Add a dropdown list to the page.
 * 3) Change the RecordSource property of the data access page.
 * 4) Add the Workflow Toolbar Control.
 * 5) Switch to Page view. Note that you receive the error message mentioned in the "Symptoms" section of this article.

Additional query words: prb switch recordsource listbox combo box list uniquetable pra

Keywords: kberrmsg kbbug kbpending kbworkflowdesigner KB245136

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.