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:
  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_<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:
  1. On the View menu, click Field List.
  2. Click the Page tab. A list of record sources for the page is displayed.

MORE INFORMATION

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.

Modification Type:MajorLast Reviewed:7/31/2001
Keywords:kbbug kberrmsg kbWorkFlowDesigner KB245136