I have a form that has 2 combo boxes that are cascading lists Category &
ClassName. If the ClassName doesn't exist in the list, the user enters the
class name (category remains blank).
I have designed a marco that searchs for any newly entered ClassNames by
checking if the corresponding category is blank. If the category field is
blank, a query uses the Nz function to add "Specify Category".
The macro then opens a form that tells the user to categorize the new
ClassName.
What I would like to do is if the macro runs and the result does find any
new ClassNames entered the form will close automatically.
Steve Schapel - 30 Jul 2005 05:55 GMT
Tim,
Can you let us know some more specific details of what you have so far?

Signature
Steve Schapel, Microsoft Access MVP
> I have a form that has 2 combo boxes that are cascading lists Category &
> ClassName. If the ClassName doesn't exist in the list, the user enters the
[quoted text clipped - 8 lines]
> What I would like to do is if the macro runs and the result does find any
> new ClassNames entered the form will close automatically.