..I guess my problem is not new, so I hope somebody can tell me something I couldn't find in FAQS...in my db there are 2 tables with many-to-many relationship: commercial estimates and products. Therefore, in my form there's a subform (shown as a recorset/table - don't know how to say in english) where user can select products to add to estimate, in order to calculate total price required.
My aim is to link together two combos so that when user selects a products_category, the second combo shows only products belonging to specified category. Here is my code:
Private Sub CasellaCombinata15_AfterUpdate()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Prodotto.Requery
End Sub
...==save (otherwise it says it can't make requery) and requery second combo box (products one).
Problems are:
1.once user has selected a product in second combo, it's impossible to re-select it (this may not depend from code, maybe my mistakes!) AND, especially,
2.IF user decides to add a second product, when he selects a different category, also previous records in recordset view suffer Requery, generating mistakes! My question is: is there a way (in recordset, not form, view) to make this requery without conditioning previous records added (I mean previous products_combo_boxes)?
Hope I was clear, please give me detailed suggestions!!!
My aim is to link together two combos so that when user selects a products_category, the second combo shows only products belonging to specified category. Here is my code:
Private Sub CasellaCombinata15_AfterUpdate()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Prodotto.Requery
End Sub
...==save (otherwise it says it can't make requery) and requery second combo box (products one).
Problems are:
1.once user has selected a product in second combo, it's impossible to re-select it (this may not depend from code, maybe my mistakes!) AND, especially,
2.IF user decides to add a second product, when he selects a different category, also previous records in recordset view suffer Requery, generating mistakes! My question is: is there a way (in recordset, not form, view) to make this requery without conditioning previous records added (I mean previous products_combo_boxes)?
Hope I was clear, please give me detailed suggestions!!!