Microsoft Access

[LAndstalker]

Hey people,

I'm putting together this applicatino at work using MS Access and I've got a button on there that I would like to have the image of change depending on a value in one of my tables.

Does anybody know how to do this? I have made a entry in my table Tabel1 and its a number, basically I want the image to change depeding on what number is in the value of it. The options are 0, 1 and 2.

What I'm after is something like:

IF value in Table1 = 0 THEN image of button = redlogo.bmp
IF value in Table1 = 1 THEN image of button = amberlogo.bmp
IF value in Table1 = 2 THEN image of button = greenlogo.bmp

I know the above is pretty much useless pseudocode but its just a guide.

Thanks

[Joleen]

I think it's something like buttonX.image = blah or buttonX.background= blah or buttonX.backgroundimage = blah.  When you put the button name then the '.' a list of available options should pop up, scroll through that for ideas.

[mims1979]

I'd say create the button at runtime.

headstart:

http://www.vbexplorer.com/VBExplorer/vb_feature/april2000/april2000.asp