Sin has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Query criteria
I set up a LIKE criteria on a query whihc allowed my users to search for a specific organisation and then based a form on it. The form and the criteria worked beautifully bringing up the record needed and then I discovered that no one can acutally edit the data! It seems that if you add a criteria to a query the data no longer becomes editable when you use a form to access it.
Is this true? - if so it would be helpful to mention it in your courses. If not, what am I doing wrong?
RE: Query criteria
Hi
I created a basic table with a query like yours, and then based a form on that query. The data seems to be editable.
How did you create the form with the criteria? VBA/macro/command button?
Have you checked the edit properties in the form properties?
Regards
Richard
RE: Query criteria
Hello,
Yes I recreated from scratch and this time it worked! - which leads me to the next problem:
Query 1 with criteria - editable
Query 2 - editable
but when I then add a field from Query 1 to Query 2, the data ceases to be editable. Do you think this is a relationship issue?
