I have a form that has an option to add a comment. Everything is fine when I am adding a new comment, but when I want to look at a note associated with a particular record in my form, I am having problems with the where condition.
As it stands, I am unable to add any extra fields to any of the tables, so the notes associated with a record have to in some other way be linked.
I know I can use the edit note command button to open the form with a certain where condition. The problem is that I continue to get an error when I try to open the form to a certain record.
I attached a copy of the Form with the relevant tables. What I would like to happen is the following
1) When a note is attached to a record on the form click the edit command.
2) When the notes form is opened, have it reference the batch form to know where to go
Attached is a copy of the form. If you select 2F125 there is a note attached to it, however, I cant seem to get to it.
Let me know if there are any other questions, thank youNotesSampleDB.accdb