Im stumped on how to have my subcategory selection filtered for a selected category on a sub form for adding transaction line items. This DB is a transaction entry for expenses, i.e. went shopping at Walmart and bought groceries, furniture, medications, automotive supplies and I am tracking when my money went.
Category may be Food, Utilities, Auto Expenses, Healthcare, Medications, etc.
Subcategory may be associates with the category or may be null (no subs) and I have that working OK.
The problem is that I need to filter for only food items in the subcategory combo select list when the category = Food, or Medications when Category is Medications based on the field Category Type in Subcategories table, or just other subcat items if they are not food or medications.
Im just beginning to learn VBA and cannot figure out how to write this code and apply it to the combo box for a third level filter.
Any gurus out there that can help with this?