Special Access Project Form Properties and Techniques

Access project forms have properties that are not available within MDB forms. These properties all help you to optimize your application for the client/server environment. Furthermore, there are techniques that you can employ with an ADP that are not available with an MDB. This section covers these properties and techniques.

Options for the RecordSource

Access project forms sport a variety of choices for the RecordSource property. You can select a table, view, stored procedure, or Transact-SQL statement as the record source of an Access project form. Creating a form based on a stored procedure is not an intuitive process. The steps are as follows:

1.
Create a form without a record source. ...

Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.