Data editing in a form

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a form that gives only a sound related to an error
whenever I try to edit the data. I have set all the
properties to allow editing and data entry for this form
but nothing helps. The Help function runs in circles it
seems. Any assitance would be appreciated.
 
If the RecordSource of your Form is a Query, open the
Query but itself, NOT through the Form and see whether you
can add / edit data on the DatasheetView of the Query.

If you can't, the Query is NOT updateable and you cannot
add/edit data in the Query or the Form based on the
Query. You can also see the ">*" (NewRecord) button in
the NavigationBar of the Datasheet disabled.

Check Access Help topic on "Updatable Queries". There are
a few tips on how to modify a Query so that it becomes
updateable.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top