Set listBox error statement

[ActMod]

Following code results in an error that says "Method 'Item' of object 'Forms' failed". Error occurs on the "Set lstBox..." line.


Dim lstBox As ListBox
DoCmd.OpenForm "frmMktSgmtSelect", acNormal
Set lstBox = Forms!frmMktSgmtSelect!lstMktSgmts


Can someone explain why I am getting this error and how it can be addressed?

Thank you for any help.

Jim

 

[CajunCenturion]

The problem that you're experiencing is one of timing. You are trying to reference an object on the form that you've just opened, but you have not given the form a chance to open, instantiate all the controls and execute all the RecordSource commands.

My suggestion would be to create a Public Sub inside you main form where you would put the Set lstBox command, and then have the new form call that sub when the form is ready.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein