O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Referencing Forms and Reports

For form and report record sources, many Access mdb applications use queries that use Forms!FormName!Control to reference control elements in other forms. With Access project forms, you can no longer use these kinds of references in queries. Access projects do not execute queries locally on the client, but on the database server instead. The database server, however, cannot access the local client to determine a value in a form.

References Between Forms

If the query for a form’s record source contains a reference to another form, you cannot simply use the solution for mdb forms with adp forms as well. Refer to the following example for an illustration.

Current Solution with Mdb Forms

Figure 10-14 shows an Access ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required