Insert image based on Value

[Y0uDy]

Hello,



If anyone could help.

I am currently re-vamping our IT Database and designing a new form for our Hardware but want to make look a bit fancy but struggling.

I want to have a picture based on a Model of a Computer/Laptop being pulled in from one of my Tables but finding it hard to make is possible.

Could anyone help me accomplish this?

Regards

Matt




The 'Model' field is looking a field in table 'Inventory' which is a 'Lookup & Relationship' to table 'Model'

[RuralGuy]

It sounds like you might be using Lookup Fields: http://access.mvps.org/access/lookupfields.htm

[Y0uDy]

I want to have a picture based on a Model of a Computer/Laptop being pulled in from one of my Tables but finding it hard to make is possible

[RuralGuy]

What have you tried?

[Y0uDy]

I'm looking to do it in VB but don't know where to start really.

I've been looking around but can't really find anything.

I don't know weather it's easy or hard to do would it go something like

"IF tblModel.Model = 'Probook 4730s' then show that picture" ????? lol not exactly that but I hope you get what I mean.

[RuralGuy]

Here's a link to 3 examples: http://accdevel.tripod.com/imaging.htm