Hi all,
I'm trying to build a convenient database for myself to use for school. It's fairly simple, with 2 tables, one listing my classes, the other used for storing homework assignments.
I have one form that lists the class, has an attachment field for notes, and a subform that is populated by the homework table. There is a separate form that I'm using to add homework assignments.
I have a button on the first form that opens the second one in dialog view, and that I'm trying to get to filter the ClassID (the field that links the tables), to whatever the ClassID on form1 is. I've been writing the filter as
[ClassID]=[forms]![form1]![ClassID]
but it hasnt been working. Can anyone help me?
I'm trying to build a convenient database for myself to use for school. It's fairly simple, with 2 tables, one listing my classes, the other used for storing homework assignments.
I have one form that lists the class, has an attachment field for notes, and a subform that is populated by the homework table. There is a separate form that I'm using to add homework assignments.
I have a button on the first form that opens the second one in dialog view, and that I'm trying to get to filter the ClassID (the field that links the tables), to whatever the ClassID on form1 is. I've been writing the filter as
[ClassID]=[forms]![form1]![ClassID]
but it hasnt been working. Can anyone help me?
