When Forms specify Record Source properties, DBMS stored procedures are created and VB.NET code is generated to retrieve results and to populate and navigate the WebForms.
Stored procedures and VB.NET code are also generated for inserting, updating and deleting records when the Allow Additions, and/or Allow Edits and/or Allow Deletions properties, respectively, are set to True AND the Access Form updates only a single table. Although the Record Source may specify a query that joins one or more tables, the enabled Access Form fields (Enabled=True, Visible=True, and Locked=False properties) must refer to a single table.
The stored procedures and VB.NET code generated for update and delete transactions employ optimistic concurrency to prevent users from simultaneous updates and/or deletes. Optimistic concurrency ensures that users do not overwrite each others updates or delete records that have been changed since they were retrieved.
Stored procedures are created and VB.NET code is generated to populate Drop Down List and List Boxes when the corresponding Access Combo and List Boxes specify a Row Source property. Drop Down Lists and List Boxes are populated only once when the WebForm is initially loaded. The Access Limit To List property is ignored and always assumed to be set to False. Code to add new entries to Drop Down Lists and List boxes must be manually written.