Originally Posted by
rtcary
That should work, however I am not sure of the syntax in Access. There is the following example:
=ComboName.Column(2)
My field, "AdID" contains the ID of the AdTbl. That comes from the user's selection of the dropdown (Field0) while Field1 contains the Description and that is displayed in the AdID field. Field2 contains the Amount and I would like that displayed as an AutoFill (coming from the user's selection from the dropdown). In other words, Description is in one field and the Amount would be in the other. Since the row ID in the AdTbl is not known until a select is made, I am stumped on how to set up the query or use the ComboName.
Todd