One Lookup table with Two needed values; how to use both

[rtcary]

The Lookup table has two fields containing values that are needed: Description and Amount ($). In the table that uses the Lookup, I'd like to have both values shown, but have a dropdown just once. In other words, when the user selects a description (the dropdown shows both the description and amount), can the amount be inserted into an Amount field as the description is done currently.

Thank you,

Todd

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

[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

[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

I figured it out...nifty!

[pbaldy]

Glad you sorted it out.