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

Record Source

Regular Access mdb forms can be based on tables and queries. With forms for Access projects, you can select tables, views, and stored procedures as record sources, as shown in Figure 10-1.

Figure 10-1. Record source selection

You can use wizards for support in creating a form, even though the wizards for diagrams and PivotTables are not available. Be sure to use the wizard only to select tables and views for the record source. If you want to use a stored procedure, you can select it as the record source only in the form’s Design view. We discuss the use of stored procedures as the record source for forms later in this chapter. ...

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