Data editing in a form

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.
 
V

Van T. Dinh

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)
 
Top