custom input box problem

[Wylie]

I'm working on a custom input box (popup = yes and modal = yes) in
Access 2000 that may be called from several different forms.

On the double click event in the calling form control:

docmd.openform "SearchForm"
forms!SearchForm.initializeForm strMode, strForm, strControl

where strForm is the form name and strControl is the control name of
the calling form.

The called search form allows them to search based upon the mode, then
upon completion writes the value back by:

If Nz(cboLookup, "") <> "" Then
Forms(strForm).Controls(strControl) = cboLookup
End If

My problem is after this writes back I can't get an event to fire on
the calling form to process the value. I tried AfterUpdate, Change,
GotFocus with no luck.

 

[Albert D. Kallal]

The problem is that model form will NOT HALT the code..so, the form
opens..but, the rest of the code
continues to run..and thus you can't capture any selections from that
form...

You need to use a dialog form, NOT a model form.

I explain the difference, and how to "return" values from a form here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[Wylie]

The problem is that model form will NOT HALT the code..so, the form
opens..but, the rest of the code
continues to run..and thus you can't capture any selections from that
form...

You need to use a dialog form, NOT a model form.

I explain the difference, and how to "return" values from a form here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

Thanks for the link. Makes me wonder what I got for my tuition.

-wylie