modification and/or additional record

[RDM]

i've got a form with a subform based on query setup
it doesn't let me modify query data or add new records via the form.
i can only assume there's somewhere i need to set permissions, but i cannot find where =/

 

[DCrake]

Simple Software Solutions

In the design of the form go to the record source property and open up the underlying query in datasheet view. Next try and edit a record. If it does not allow you to do so, which I suspect, you have a non updatable query. This will normally be due to the links and indexes you have on the tables. If I does allow you to edit the query then the issue lies elsewhere. Try and answer the my first question before proceeding further.

CodeMaster:

 

[RDM]

In the design of the form go to the record source property and open up the underlying query in datasheet view. Next try and edit a record. If it does not allow you to do so, which I suspect, you have a non updatable query. This will normally be due to the links and indexes you have on the tables. If I does allow you to edit the query then the issue lies elsewhere. Try and answer the my first question before proceeding further.

CodeMaster:

Subform doesn't allow modification or additions of records in datasheet view.

I don't know what indexes or links are.

I've just discovered that the query itself does not allow modification or additions of records.

Interesting. I'll look into that further and update as required.