• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Form Problems

Q1:I can't add a new record to a form that's bound to a Jet query.
A1: The most likely cause of this problem is that the query you're using as the record source for the form isn't updatable. Run the query and verify that the tentative append record appears after the last record with data. If the tentative append record is present in the datasheet, then you might have accidentally set the Allow Additions property value to Yes.
Q2:The text boxes on my form are empty, the Next and Previous record navigation buttons are disabled, and the First and Last record buttons don't work.
A2: You accidentally set the Data Entry property of the form to Yes. Setting the Data Entry property permits adding new records, but prevents the user from seeing existing records. Why the First and Last buttons are enabled is a mystery. This problem also occurs with subforms and often results from selecting the form instead of the subform when setting the Data Entry property value.
Q3:No controls appear on my form in Form view.
A3: You set the Allow Additions property to No, and accidentally set the Data Entry property of the form to Yes. In this case, subforms don't appear on the form. There have been many requests by Access users and developers to display an error message when you specify these mutually-exclusive property values. (New Access users have been known to panic after having spent several hours designing a form and then seeing their work disappear in Form view.) The problem also applies to subforms but isn't as dramatic.

Subform Problems

Q1:The subform I added to the main form doesn't change its data when I move the main form's record pointer with the navigation buttons.
A1: You didn't create the required link between the main form and the subform in the Data page of the main form's Properties window, or the link is broken as the result of changing a table or query name.

Select the subform control of the main form (not the subform itself) by clicking the edge of the subform in Form Design view, open the Properties window, and click the Data tab. Click the Builder button to open the Subform Field Linker dialog, and add or correct the field names of the linked tables or queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint