MOD2000: Workflow Toolbar Error Message When You Change the Record Source of a Data Access Page (245136)
The information in this article applies to:
- Microsoft Office 2000 Developer
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:
- In Design view of the page, double-click the Workflow Toolbar Control to display the properties sheet.
- Click the first Data tab from the left.
- 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_<table or view name>).
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:
-
On the View menu, click Field List.
-
Click the Page tab. A list of record sources for the page is displayed.
Modification Type: | Major | Last Reviewed: | 7/31/2001 |
---|
Keywords: | kbbug kberrmsg kbWorkFlowDesigner KB245136 |
---|
|