My form "Associations" has a number of fields: Group, Position, Date Appointed,etc.
The form "Associations" is a sub-form of another form 'Members'.
The field 'Group' in the 'Associations' form is linked in a one is to many relationship with a field 'Group' in a table 'Group'. The 'Association' 'Group' field's propoerty 'Look Up' is set to COMBO. The relevant table is listed as the table 'Group' field 'Group'.
I have created a macro that initiates in the instance where I try to enter data that is 'NotInList'. My macro works but I have two problems. 1. Because an incorrect entry is in the field, the table won't close and I can't seem to remove the offending entry. 2. I have to manually 'Refresh' to get the new entry into the COMBO BOX list. Can anyone suggest a way to: 1. automatically delete the offending text in the filed to make the program believe there is still no entry and so not start an error macro, and/or 2. automatically allow me to update the table 'Group' and refresh the database?