I'm currently using access 2003. I have a sub form that is linked to a table with a few fields including a reference id (explained later) and an auto number.
the reference id refers to an aspect of the main form that is then used in a where statement for the recordset for the subform.
(example to explain. we are looking at item 1 on main form. subform shows all records where reference id = 1)
I was trying to use an after insert event to go and update the database, but that is not firing and not erroring.
question: what could cause this to not fire/what is a solution to this -or- what is another/better method to solve this problem?