Cannot Edit in Subform

[china99boy]

Hi all, I have a search form that pulls data from a query. The data is displayed in a subform. I would like the user to be able to edit the data from the subform. I have set all the allow properties to yes and it still doesn't work. Does this problem have anything to do with relationships.

Thanks to all, this forum has been a great help for me.

 

[DES]

Sounds like the record set for the subform is not updateable. If it is based on a query try opening the query and see if you can add a record there. If you can not then you will need to modify it so it can be updated.

 

[china99boy]

Ok, I have open up the query and I can make changes there. What do i need to do at this point? Thanks for your quick response.

 

[DES]

If you can edit the query for the subform then you have another problem. If you want to send me a sample I will look at it for you.

 

[china99boy]

You will need to hold the shift key to enter.

 

[china99boy]

Can someone take a look at my database and tell me how to configure it to be able to edit from my subform using my search form. I have included my database above. Please help, I really need to get this completed. Thanks in advance.

 

[china99boy]

Has anyone had a chance to take a look at my problem. I can make changes from the query itself, but not from within the subform. What am I missing. I a query to join two tables. One of my tables doesn't have a primary key. Could this be the problem. Please guys, point me in the right direction.