Error 424 in Auto Fill

  • Thread starter Thread starter KsFireworksGal
  • Start date Start date
K

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?
 
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.
 
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.
 
Double check to ensure your data types match, your names are correct, and the
syntax is correct for the data types.
 
Back
Top