When you type data into a new record on a form that is
based on a query or an SQL statement, you receive one of the following error
Multiple-step operation generated errors.
Check each status value.
Start position is before the beginning or
past the end of the rowset. No rows were returned.
When you click OK
, you can continue to edit, and then you can save the record.
This behavior occurs when you try to update a read-only
field in a record by using either the DefaultValue
property or Visual Basic for Applications.
Do not use the DefaultValue
property or Visual Basic for Applications to edit read-only
When you create a form that is based on a query, any
control that is bound to a query field that contains an expression is
read-only. Because the query expression is not bound to any specific field in
the underlying table, you cannot edit the values in these fields. However, when
you set the DefaultValue
property of such a control, Access tries to write a new value to
that control every time that you add a new record.
Steps to Reproduce the Behavior
- Start Microsoft Access
2002 or Microsoft Office Access 2003, and then open
the sample database Northwind.mdb or the sample project NorthwindCS.adp.
- Open the Orders Subform form in Design view.
- Click in the Extended Price text box. On the View menu, click Properties, and then set the DefaultValue property to 0 (zero).
- Close and save the Orders Subform form.
- Open the Orders form in Form view, and then add a new item
to any order. Note that you receive one of the error messages that are
mentioned in the "Symptoms" section of this article.