A2007 ListItemsEditForm

[JimS]

I've set a popup form as the ListItemsEditForm propertyof a combo box on a
form, and it works just fine. Problem is, I want the popup to be able to
refer back to the calling form and extract the value from that combo box that
triggered the ListItemsEditForm event.

Must I use the "NotInList" event instead?

 

[Albert D. Kallal]

I've set a popup form as the ListItemsEditForm propertyof a combo box on a
form, and it works just fine. Problem is, I want the popup to be able to
refer back to the calling form and extract the value from that combo box
that
triggered the ListItemsEditForm event.

Must I use the "NotInList" event instead?

You should be able to simply reference the listbox in that form.

For example, the code to make the popup form "move" to the record selected
in the listbox, you could use the following code in the popup form:

Me.Recordset.FindFirst "id = " & Forms!form1!List0


And, while we are at this, I don't think you need the form to be popup, but
simply setting the form as model should suffice here.

 

[JimS]

Code I used:

If CurrentProject.AllForms("frmestimatedlaborspread").IsLoaded Then
Me.cbWOID = Nz(Forms![frmEstimatedLaborSpread]![cbWOID], 0)
End If

(isloaded property is True...I checked...)
Always returns a null.

I'm not finding this in a recordset. Once I get a workorderid (WOID), I
insert records into a related table which, by definition, has no entries for
that work order.

 

[JimS]

Albert,
I don't know how this happens, it's entirely undocumented...The OpenArgs
contain:

"[frmEstimatedLaborSpread]![cbWOID]=4306593"

when the PopUp was called by the ListItemsEditForm event procedure.

Who'da thunk?