Knowledge Base

RecordSource Property Syntax Incorrect in Access 97 Help

Article ID: 161031

Article Last Modified on 1/19/2007

Microsoft Access 97 Standard Edition

This article was previously published under Q161031

Novice: Requires knowledge of the user interface on single-user computers.

SUMMARY

The "RecordSource Property" topic in the Microsoft Access 97 Help system contains a syntax error. The example in the "Sample setting" section of the Help topic reads as follows:

SELECT Orders!OrderDate FROM Orders;

This is incorrect.

The correct syntax for this example is:

SELECT Orders.OrderDate FROM Orders;

Note that the correct syntax uses a period (.) after "Orders" instead of an exclamation point (!).

Additional query words: inf

Keywords: kbhowto KB161031