Form Not Updatable

[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

 

[Cheryl Fischer]

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.

 

[Crispy]

That seems to be the case - Thanks

BUT - How can I correct it?

 

[Cheryl Fischer]

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.