set value in a form

[Ivor Williams]

I have a form with a combo box. The NotInList event causes a second form
(not a subform) to open. I would like to have the value in a field on the
second form automatically set to the same as the value in the combo box on
the first form which triggered the NotInList event. I tried to use
DoCmd.SetValue when the second form loads, but no luck. Please help.

Ivor

 

[Al Camp]

Ivor,
I'd try the OnCurrent of the 2nd form to trigger getting the
value.
Use a full "address" when referring to the 1st form combo
field.

Me.My2ndFormField = Forms!frmMyFirstForm!My1stCBO

... that should do it.