Forum home » Delegate support and help forum » Microsoft Access Training and help » access 2003 training course london - Query criteria
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access 2003 training course london - Query criteria
Resolved · Low Priority · Version Standard
Reply Wed 6 Jun 2007, 10:19Delegate Sin said...
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?
For upcoming training course dates see: Pricing & availability
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
Reply Thu 19 Jul 2007, 13:09Delegate Sin said...
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?
|