Combo Boxes, Selections, frustrations

[redbull]

Alright, So I have a small app. Then end goal is to do something that performs similar to the search on the kelly blue book site.

http://www.kbb.com/car-values/

I have created a table that holds all the car makes (tblmake) and this is linked to a combobox on the form.


Problems I am having..

1. Despite being able to see the selection of car makes in the combo box.. nothing happens when I click on it. The drop down remains open and nothing is selected.

2. After the above problem is solved. I will want the 2nd combobox to offer a drop down of the car models... So if the person chooses Chevrolet in the first dropdown box, the second will only display models for that make.


....

Any suggestions to my first problem? Any suggestions for database / Form design? I am super new to combo boxes, figured this was a good way to learn about them.

[pbaldy]

1 sounds like the form or control is locked, or the record source is read only. This should help with 2:

Baldy-Cascading Combos

[ssanfu]

Hard to say without more info or seeing your mdb.

You are trying to set up cascading combo boxes. Maybe this will help you. Attached is a mdb with a 7 combo box cascade - one form uses combo boxes and the other uses list boxes. I used the list boxes to see what I was doing, but it takes up a LOT of real estate!!

If you can't get it solved, do a "compact and repair" on your mdb, Zip it, then upload it.

[redbull]

Hmm, well the combobox itself is not locked. and the Record source is a table within the same database, and I am not sure where to check if it is read only. I right clicked and checked properties but nothing is marked read only... If I sound like a noob, its because I am.

[redbull]

Hard to say without more info or seeing your mdb.

You are trying to set up cascading combo boxes. Maybe this will help you. Attached is a mdb with a 7 combo box cascade - one form uses combo boxes and the other uses list boxes. I used the list boxes to see what I was doing, but it takes up a LOT of real estate!!

If you can't get it solved, do a "compact and repair" on your mdb, Zip it, then upload it.

Hmm not seeing the attachment.

[redbull]

Alright here is a copy of what I have so far, Please ignore the obviously irrelevant code. I am just reshaping an old app. Unrelated.zip

[pbaldy]

You can't make selections because of the control source of the combo.

[redbull]

I tried changing it a bit but can't get it working.

[pbaldy]

I deleted it and was able to select any option.

[redbull]

Wow you're right... Well... thank you for everyone's time. And with that being done, your example from your site is how I plan to move forward!

[pbaldy]

No problem. It can have a field as the control source if you wanted to save it, but not a formula.

[redbull]

Hmm, this is a little bit off topic... but Could ( on your example ) be replace cbostate with a label?

I am trying to do this...

SELECT [tblTest].[Problem] FROM tblTest
WHERE ((([tblTest].[Atype])=[Forms]![frmMainnew]![lblAtype]))
ORDER BY [tblTest].[Problem];

Or to keep it in your example...

SELECT [Cities].[City] FROM Cities 
WHERE ((([Cities].[State])=[Forms]![CascadingComboSample]![cboState1])) 
ORDER BY [Cities].[City];

I want to do this

SELECT [Cities].[City] FROM Cities 
WHERE ((([Cities].[State])=[Forms]![CascadingComboSample]![lblState1])) 
ORDER BY [Cities].[City];

The Label value or caption is dependent on a webpage variable.. for example, currently lblAtype is set to "laser printer"

Then in the tbltest I have 2 columns. One with Atype and another with Problem.
Under Atype, I have "laser printer" and then in the other column I have a list of problems for that Atype. All of this is on a form named "frmMainnew"..

[pbaldy]

Could be, but I've never tried. You'd have to refer to the Caption property of the label, as it has no Value property, which is the default when unspecified. Try

[Forms]![CascadingComboSample]![lblState1].Caption

[redbull]

YES!! Small moment of victory here... I tried this before your answer and both failed..

[caption.lblState1]
[lblState1.caption]
["lblState1"]

So I was on the right path... just wrong placement! Thank you again very much...

[pbaldy]

Happy to help!