NotInList Requery fails in a macro

[Dick de Jong]

I have applied the NotInList event of a combo in a data entry subform, to activate a macro that opens another data entry form. This allows the user to enter the item missing from the drop-down list. The macro's next item is Requery but it is not updating the first form: I have to do this manually by closing and opening the form, or selecting Records, Refresh.

Instead I get an error message saying 'You can't use the ApplyFilter action on this window...Use the SelectObject action....' This the first time I have tried macros. I have looked up the Help menus and from there tried including the action SelectObject in the macro, and setting the second entry form's properties Modal=Yes, Popup=Yes, Allow Filter=No and boarder=dialogue, without success. Any ideas? I am using Access 2000.

 

[jeremie_ingram]

I would put the requery for the form in the close event of the other form. Form1 opens, the trigger form2 to open for data entry, when form2 closes its onclose function would trigger the form1 requery/refresh.

The macro is probably functioning fine, just running the requery b4 the data is entered. It opens the form, then continues with the requery. Since it only looks at the open form, it wont wait for the data to be entered for the next command to be executed.