Combo And Images

[deltarepairs]

Hi
I have 2 combo dynamic combo boxes : phone make and phone model. when I select for example: Nokia on phone model, phone model will show only nokia models,
What I need 2 thongs to add to this project.
1- After selecting the phone make I want the phone model to drop down automaticly with out the need to click on it,
2- and this is important: that if I select from the list a model 1100 i want the photo to show that model, or if i select another model i want the same model of the selected model to show.


Kind Regards

[NeoPa]

Hi.

I've split this post into its own separate thread according to our rules. I'm afraid your post was a thread hijack and not allowed. It's your first post so I won't make a song and dance about it, but please check out our posting guidelines at FAQ - How to Ask a Question.

Welcome to Bytes!

[NeoPa]

What I need 2 thongs to add to this project.
1- After selecting the phone make I want the phone model to drop down automaticly with out the need to click on it,
2- and this is important: that if I select from the list a model 1100 i want the photo to show that model, or if i select another model i want the same model of the selected model to show.

1. I don't believe there's a way to accomplish this. There may be someone who's found a way to handle this using the SendKeys statement, though. See what turns up.
2. There is an AfterUpdate event for the ComboBox. I would handle the event and show the picture within the event-handler procedure.

Let us know how you get on with this. What, if anything, you can't manage without further help.

[ADezii]

Hi
I have 2 combo dynamic combo boxes : phone make and phone model. when I select for example: Nokia on phone model, phone model will show only nokia models,
What I need 2 thongs to add to this project.
1- After selecting the phone make I want the phone model to drop down automaticly with out the need to click on it,
2- and this is important: that if I select from the list a model 1100 i want the photo to show that model, or if i select another model i want the same model of the selected model to show.


Kind Regards

1- After selecting the phone make I want the phone model to drop down automaticly with out the need to click on it,

You can activate the DropDown() Event of the Phone Make Combo Box.

2- and this is important: that if I select from the list a model 1100 i want the photo to show that model, or if i select another model i want the same model of the selected model to show.

A 'Hidden' Column in the Model Combo Box can contain the Absolute/Relative Path to a Graphic Image representing that Model. This Image in turn can dynamically be loaded into an Image Control. You can alternatively use a Lookup Table for Image Access, or store the Images internally in an OLE Object Field.

[OldBirdman]

Me.YourCombobox.SetFocus
Me.YourCombobox.Dropdown

[NeoPa]

1. I don't believe there's a way to accomplish this. There may be someone who's found a way to handle this using the SendKeys statement, though. See what turns up.

Wiping egg from face...

I'm so glad I added that last sentence. Thanks guys for having my back :)

[OldBirdman]

I would suggest that your image names, or the images, be stored in a separate table. This would allow for multiple images for a single object. Front / Back view, color options, etc. This could not be done with a hidden column of the combobox, however.

[ADezii]

Wiping egg from face...

I'm so glad I added that last sentence. Thanks guys for having my back :)

Don't be so hard on yourself, you were actually 1/2 correct! (LOL)!

Me![<Your Combo Box>].SetFocus
SendKeys "{F4}", True