So,
I know how to create cascading combos, I know how to create not in list to add new data.
The part im stuck on is how to combine them in this situation.
I have a form for input of issue records for an employee for Equipment (which is a subform).
Equipment need to be selected from combos (cascading).. Type, Make, Model, Serial
So 1st combo is Type, not a problem, this can be a lookup table which not in list works.
2nd Combo... this is where I fall over...
Ive tried all sorts, using linked tables, all in one equipment table(as I believe it should be), i just dont know how to format the VBA that if the item is not in the afterupdate list, create a new entry but then any combos down the chain add the data to the same row.
Please help
I know how to create cascading combos, I know how to create not in list to add new data.
The part im stuck on is how to combine them in this situation.
I have a form for input of issue records for an employee for Equipment (which is a subform).
Equipment need to be selected from combos (cascading).. Type, Make, Model, Serial
So 1st combo is Type, not a problem, this can be a lookup table which not in list works.
2nd Combo... this is where I fall over...
Ive tried all sorts, using linked tables, all in one equipment table(as I believe it should be), i just dont know how to format the VBA that if the item is not in the afterupdate list, create a new entry but then any combos down the chain add the data to the same row.
Please help
