Cascading combo boxes code - ARGH!!

[vangogh228]

Hi all... and thanks for your help to this very frustrated moderate Access user. I have been using an example for cascading combo boxes in a timesheet form, but I simply cannot get it to do what I need.

I have a table called "Entry", with a form called EntryForm based on it. That table has the follwing fields:

Name
Date
Hours
Set* cboSet
Subset* cboSubset
Item* cboItem

The fields with asterisks are the ones I am trying to create cascading combos for. I have a table called "Sets" which has the same fieldnames in it, which I am trying to use as the sources for these fields. The form has "cbo" in front of the names. I have attached my code in a document.

It looks like all this does is act like an Excel autofilter. Can someone help me with the sourcing for these fields and how I get the Entry table to populate as I make entries. All my code does is push me to edit the Sets table records.

Thanks for any help!!

 

[Rich]

Table are meant to hold data not to enter data directly into. Use a Form to enter the data where you can use cascading combo boxes

 

[vangogh228]

Allow me to quote myself...

"I have a table called "Entry", with a form called EntryForm based on it."