Form Not Updatable

  • Thread starter Thread starter Crispy
  • Start date Start date
C

Crispy

I have tried on a number of occasions to solve this problem before.....

I am making a database of over 1600 CD's and Vinyl Albums..

I can, and do get a great looking form including titles, artists, media,
length, tracks, year etc etc.....

However, when I try to add a new record through the "add record", I cannot
add in ANY field?

Any views?

Thanks
 
A couple of things to check ...

Form Properties:

Allow Additions should be 'Yes'
Allow Deletions should be 'Yes'
Allow Edits should be 'Yes'
RecordSet Type should be 'Dynaset'

Record Source:

Are you using a query as the Record Source of your form? If so, and the
query pulls data from more than one table, it *may* be that the query itself
and therefore the record source of the form is not updateable.
 
What seems to be the case? That you do, in fact, have a query behind your
form that is not updateable?

In that case ... you may want to investigate the use of subforms. Access
Help topic Getting Started will have an overview of databases and their
objects. Then you can navigate to the Forms topic. Try it and post back
with results or questions.
 
Back
Top