Remove selected Item (Continuous Subform)

[Falcon88]

hiiii all

i have a combobox in my subfrm, i want to hiden the selected test from the combobox rowsource in the next record.
i used subsquery with "Not Exisits" statement as a rowsource for the combobox.

this works good when the default view of subform "data-sheet". but for some reasons i need to use "Continuous Subform".
when i use Continuous Subform , the previous records in that Continuous Subform disappears.
please see to the attached example.

and

Is the using of (subsquery with "Not Exisits" statement ) a practical solution s a rowsource for the combobox ?
and
give me a solution for the problem of the disappears of some previous records in the subform .

 

[JHB]

I get an error when I open your database.

 

[Falcon88]

ok

this attached file without zip.

 

[JHB]

Still getting the same error.

 

[JHB]

Never mind, I've created a new subform, then the error went away.

 

[JHB]

Sorry - you can't get that to work, the best you can do is showing a message that the testno already is chosen.