When I try to execute the following :

   "strProduct = [lstLookup].Column(0)

    strPN = [lstLookup].Column(3)

    strPrinter = [lstLookup].Column(4)

    strInk = [lstLookup].Column(6)

    strcolor = [lstLookup].Column(8)

    strSize = [lstLookup].Column(11)

        

    ' Assigns value to controls in frmOrderDetail

    

    Form_frmOrderDetail.fldProductID.SetFocus

    Form_frmOrderDetail.fldProductID.Text = strProduct

    Form_frmOrderDetail.txtPN.SetFocus

    Form_frmOrderDetail.txtPN.Text = strPN....



I get  runtime error 2101: "Setting isn't valid for this property"

All I want to do is give the textboxes on another form the values from a 

listbox in another. It worked at first then stopped. Am I using the wrong 

approach? I'd appreciate any help.

Thanks







    

Do you get the same result if you use the .Value properties of your text

boxes instead of .Text?



-----Original Message-----

From: phil remy [mailto:phil@p...]

Sent: Thursday, May 10, 2001 3:47 PM

To: Access

Subject: [access] Run Time Error 2101





When I try to execute the following :

   "strProduct = [lstLookup].Column(0)

    strPN = [lstLookup].Column(3)

    strPrinter = [lstLookup].Column(4)

    strInk = [lstLookup].Column(6)

    strcolor = [lstLookup].Column(8)

    strSize = [lstLookup].Column(11)

        

    ' Assigns value to controls in frmOrderDetail

    

    Form_frmOrderDetail.fldProductID.SetFocus

    Form_frmOrderDetail.fldProductID.Text = strProduct

    Form_frmOrderDetail.txtPN.SetFocus

    Form_frmOrderDetail.txtPN.Text = strPN....



I get  runtime error 2101: "Setting isn't valid for this property"

All I want to do is give the textboxes on another form the values from a 

listbox in another. It worked at first then stopped. Am I using the wrong 

approach? I'd appreciate any help.

Thanks