Subform Not In List Event

[dynamictiger]

I have made a form to handle not in list events. It works fantastic until I hit a subform.

The procedure works by setting properties in the calling form for the the recordsource of the combobox and the field we are trying to add new data too. The newdata and the formname are passed as openArgs.

As you can see my problem is that the subform Me.Name property returns the form name of the subform not the name the subform is opened by. I have tried playing around with string expressions to make this work for a subform but don't seem to be able to get the correct syntax.

Anyone got a better idea?

 

[RickSpr]

Since you're passing a form name, I assume your NotInList form accesses the calling form using the Forms collection. That's not going to work for a subform, because it isn't in the Forms collection.

I think what I would do is abandon using OpenArgs. Instead, create some Public module-level variables in a standard module, and use them to pass the newdata (a string) and a reference to the form (Dim frmCaller As Form). The calling form then just does Set frmCaller = Me, whether it's a main form or a subform. In the NotInList form, you reference the properties and controls as frmCaller.RecordSource, frmCaller!Combo1, etc.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein