Cascading Combo Repeating Fields

[Carolinec]

I know I should know the answer to this but I just can't remember how I've
solved this in the past!! I've had a browse through other questions but can't
quite find one that suits.

I am creating a plant and flower database for planning out flowerbeds.

I am in form view. My form is set to display as a datasheet.

If the user selects "tree" from my first combo field, my second cascading
combo then displays all the trees for the user to select.

I would then like the user to move onto the next record (directly underneath
in the datasheet view) and perhaps select "Herbacious" and select then a
herbacious plant, etc.

However, when the user moves onto the next record directly under, it repeats
exactly what is in the first record and if I change record number 2 then the
first record also changes to what I have selected.

I know the answer is simple but I can't remember!!!

 

[Douglas J. Steele]

Actually, it's not all that simple.

See my February, 2006 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
at http://www.accessmvp.com/DJSteele/SmartAccess.html