How can I get a form in an Access database to let me use images in a dropdown as the choices?
March 25, 2010 1:11 PM Subscribe
How can I get a form in an Access database (I'd like to make a web app, but my hands are tied and I must
use Access) to let me use images in a dropdown as the choices?
posted by Brian Puccio to computers & internet (6 answers total)
I'm familiar with actual database software and can write some VB if that's the path I need to take. Right now I've got one table (Assessment) with several fields, the majority of them being lookups of other tables and queries. For one field, it's looking up a query called AvailableAssessmentSkillChoices. This query has a few fields, Choice (text), Image (OLE Object), Sort Order (Number) and ID (AutoNumber). I have no problem making the field Assessment table lookup this query.
My issue is, I'd like to make the Image what's displayed in the dropdown on the form, preferably without the Choice field, though I'll settle for displaying Image and then the Choice field next to it. What am I overlooking? I have no problem making any other field or combination of fields what I see in the dropdown. Or is this just yet another reason I don't want to use Access?