I have a query attached to a form. On that form I have a
combo box w/ a 'notinlist' event that is supposed to add a
record if the 'id' is not in the list. I use a
docmd.gotocontrol to do this but when it tries to add the
record, an error saying the query isn't open. I thought
since the form is active the query would be ready to
accept a new record?