LisaP
01-05-2001, 04:39 AM
Hope someone can help with this, or suggest a better way of doing?
I have a form for user entry [CallsAdd] which has a combo box listing user names [ComboUser] based on a table. I have created a macro for the NotInList event of the combo box that will open a pop-up form [FrmDialog], this form has two command buttons - one closes dialog and allows user to reenter name (in case of typo's!) and one that will open [UserAdd] form for entering new data - phew! My problem is that i have entered code in the on close event for the [FrmDialog] to requery the combo box, but i keep getting a runtime error - saying need to save current field b4 requery action.
Help!
I have a form for user entry [CallsAdd] which has a combo box listing user names [ComboUser] based on a table. I have created a macro for the NotInList event of the combo box that will open a pop-up form [FrmDialog], this form has two command buttons - one closes dialog and allows user to reenter name (in case of typo's!) and one that will open [UserAdd] form for entering new data - phew! My problem is that i have entered code in the on close event for the [FrmDialog] to requery the combo box, but i keep getting a runtime error - saying need to save current field b4 requery action.
Help!