Can't add new item or edit form

[Anne]

Hello,
When I base my form on one table I am able to add a new item to a form or make it read only. This I do using the forms data property. If I base my form on a query or more than one table via the wizard by form is always read only, even if I change the data property parameters. I am new to access and can't figure this out! thanks in advance.-Anne

 

[OutbackInvestments]

As far as I understand access queries (I dont use them much, I work around them) a query only accesses the data. It doesnt allow a change to be made. Like in a report, you can view the data as it would be printed, but you cant change the data. Same thing with a query (as I understand them)

 

[Rich@ITTC]

Hi Anne

You can update data through queries and to be honest that is a vital part of Access design (or any Relational Database). I have to say that the suggestion to avoid using queries is very misleading - queries give you enormous power and potential to any database.

It is true that sometimes queries are not updatable, perhaps because they contain a calculated field (i.e. a new field created via a combination of values in other fields or created via some sort of mathematical calculation based on a field)or a field in one of your tables is set to Required = Yes, but you have not selected this field to appear within your query.

Try adding all the fields available in both tables to see if you can make your query updatable. Queries that are not updatable are called "snapshots" - those you can update are called "Dynasets". Check in the Access Help file or get hold of a good book on Access (Developer's Handbook) by Paul Litwin and Ken Getz is excellent. These sources will help you considerably, but what ever you do persevere with Queries - they are excellent tools for making a database a very powerful programme.

I hope that helps.

Rich

 

[Richie]

Are you sure you haven't got unique records/values set to yes?