I can't enter text in a bound text box

[Jerry8989]

I have a form with many bound text fields. For this form I started with 1 table but now I have to left join to a different table to check if there are any rows. After I added this second table I can't edit my text fields.



This is an example of what i'm doing

Select a.*, IIf(Len(b.id) Is Null,No,Yes) AS chk
FROM a LEFT JOIN [select distinct id, AmId from notes]. AS b ON (a.AmId = b.AmId) AND (a.id = b.id)

Did adding that check some how stop me for editing my fields that go with table a? I need to check if there is a row in table notes if there is i'm binding it to a checkbox so the user knows there is notes or not.

This is an emergency so any help would be greatly appreciated.

[dcrake]

It may be because the way you have contructed the query makes it an uneditable query. Suggest you try and open the underlying query as a query and try to edit a field. You should get a statub bar message stating that this record is not updatable.

David

[RuralGuy]

I find this link helps me sort out why a query is not updateable.

[Jerry8989]

Thanks to both of you for your help.
It is the distinct that is causing the problem. What would be the best approach to create the type of flag I'm trying to create? I just want to let the user know if there are notes by having my checkbox have a check mark in it. The checkbox can't be changed or updated it's just a display feature. The notes table can have multiple rows per id that is why I was doing a distinct. Do I even need the distinct?

Thanks again