editing a query in a form?

[blooberrys]

I have a query that i wish to be able to edit when it is viewed as a form.

i get the message the recordsheet is not updatable.

i have had this form in my database for a while and it used to work so im not sure what has happened.

help please

thank you

 

[Khalid_Afridi]

Hi,
Check your query if it is updatable or not? your query could have inner joins which might have preventing your data to be updated.

 

[vbaInet]

Reasons why your query is unupdateable -->

http://allenbrowne.com/ser-61.html

 

[blooberrys]

thanks for getting back to me.

how do i check if my query is updatable?

 

[vbaInet]

thanks for getting back to me.

how do i check if my query is updatable?

Our posts crossed. Look at the link provided in the post above.

 

[blooberrys]

I have this problem fixed now thank you very much!

 

[vbaInet]

Happy to hear!