Error 424 in Auto Fill

[KsFireworksGal]

I know that you can use an combo box to autofill one field in a form based on
another field's answer. I have done it before, but for the life of me I
can't get it to work in today.

I am entering in my form based on Box Detail Table the following:

Box Number - combo box - general number based on table Assigned Box Numbers
Description - combo box - type or select the items description based on the
Product Master Table
Item No - combo box - I want this to auto fill based on the selection of the
description box
Quanity - manually entered number
Packaging - combo box were user selects from four preset options (each, box,
pack, brick).

I have created all my combo boxes - all but the Item No works. I have the
Item No selecting the info from the correct table and I have the following
event procedure on enter

Private Sub Combo62_Enter()
Combo62 = ITEMDESCRIPTION.Column(1)
End Sub

I am getting a run time error 424 Object Required.

What am I missing?

 

[Klatuu]

First thing is to qualify your objects. Second, That is not a good event to
use for what you are doing. I would suggest the After Update event of the
ITEMDESCRIPTION combo:

Private Sub ITEMDESCRIPTION_AfterUpate()
Me.Combo62 = Me.ITEMDESCRIPTION.Column(1)
End Sub

Just to be sure you know, Column(1) is actually the second column of a combo
box. The ItemData collection index is zero based.

 

[KsFireworksGal]

Thank you, yes I am aware that column (1) is acutally column to in my
ItemDescription Drop combo box I have column (0) as Description and Column
(1) as ItemNo.

I tried you suggest and moved the even procedure to the after update on the
ItemDescprition now I get Run-Time error - '147352567 (80020009)' Invalid
value entered for field.
Any Suggestions.

 

[Klatuu]

Double check to ensure your data types match, your names are correct, and the
syntax is correct for the data types.