access 2007 combo boxes

[jerken]

Im working in Access 2007 using two Combo boxes to select a category then product type. I am trying to get a couple fields to be displayed based on what the values are in the combo boxes. I have the boxes properly synchronized and working fine. Is there like a submit button I can input or a an after update I can create? I have been searching online and I cannot find anything. here is the code i have for the boxes. there are a couple different forms I would like to do this with, but I just cannot get it to work

Me.cboProducts.RowSource = "SELECT ProductName FROM" & _
                        " Products WHERE CategoryID = " & Me.cbocategories & _
                        " ORDER BY ProductName"
 
Me.cboProducts = Me.cboProducts.ItemData(0)
 

[dsatino]

Not totally clear on what you're trying to do, but this is what I think you're trying to do. The attached file has an operational form. You'll have to look at the properties and the code, but it's very minimal.

[jerken]

well its not exactly what Im looking to do. I basically I have two combo boxes (state and county) and I want when you select a state, the conty box only shows the ones for that state(that part I have working). then when you choose the county, it would only show the attachments for that county(field1).

[dsatino]

Where are you displaying these 'attachments' and where are they stored?

[jerken]

they are on the table with the county. I Change the field to attchment and then put the file(s) onto that table. Then used the lookup field to associate the county with the state

[dsatino]

Ok, still not totally sure...this is my best guess without a visual

[DanicaDear]

Jerken,
I'm probably the last person you'd want helping you on a DB right now (LOL) but I've received so much help here I feel it's my obligation to try to help somebody else. There is a sample DB provided in this string that may be on the same lines of what you are trying to do.
Just look in post #3 and don't drown in the rest of the post. :-)
Welcome to Bytes!
Danica

http://bytes.com/topic/access/answer...ther-combo-box

[jerken]

@DanicaDear
that is actually what I am trying to do. Now I just need to get it to do the same for mutiple text boxes. Thank you this is a huge help!

[DanicaDear]

Perfect. Pay attention to the properties boxes and make sure properties are set similarly. If I could do this, anyone can!! Good luck!