BUG: Queries or Views Do Not Appear in Data Form Wizard
Article ID: 190221
Article Last Modified on 4/18/2003
APPLIES TO
- Microsoft Visual Basic 6.0 Professional Edition
- Microsoft Visual Basic 6.0 Enterprise Edition
This article was previously published under Q190221
SYMPTOMS
When you use the Data Form Wizard, queries or views do not appear in the
list of available record sources.
CAUSE
The Data Form Wizard incorrectly queries only for tables to populate the
drop-down combo box of available record sources.
RESOLUTION
Select a table that closely matches the desired query to build your form,
then change the RecordSource property of the generated ActiveX Data Objects
(ADO) control (datPrimaryRS) to the desired query.
STATUS
Microsoft has confirmed this to be a bug in the Microsoft products
listed at the beginning of this article. We are researching this
bug and will post new information here in the Microsoft Knowledge
Base as it becomes available.
Keywords: kbbug kbaddin kbpending KB190221