Cannot Change Data on a subform

[chris_jolly]

Hey All,

I have a form with 2 subforms, both of which are queries. I need one of them to allow for data input/editing. I had it working for a while but now it does not work. Is there a process that I can make one of the them allow for data input?? Is it because Im using a query?

Thanks

 

[Rabbie]

If your Query is read only then you won't be able to use it for data input/editing.

see this link for more info
http://allenbrowne.com/ser-61.html

 

[chris_jolly]

I checked most of the bullet items but need some help on a couple.

Where do I find if my query has a transform clause?

Can you also elaberate about the JOINs issues. Im not sure what the proper index would look like.

Everything that is linked up to the query is a primary key, so I wouldnt think this would be my problem.

 

[Rabbie]

Look in the SQL view of the query. I think it unlikely there is a transform clause. The quick way to check if the query allows writes is to open it in data mode and se if you can add a new record at the bottom. If so it's not read-only