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!...

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

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).

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...