Combobox1 = DLookup("[V05 GOVT]", "End of year incentive", "[AS400 #] = " _
& [Cell T28])
Is there a way to have ComboBox1 on Excel spreadsheet and it do a lookup in
access database

Cell T28 = Field in Volume.mdb [AS400 #]
Lookup Database Volume.mdb
Table [End of year incentive]
Field [V05 CONV) and the result would be in combobox1

--
ca1358