problem with cascading combos A97

[li'l red]

I have a relational table based on 5 other tables,
and a main table based on the same 5 tables.

I have a form with 5 cascading combos based on the main
table.
each combo grabs the id and text field from one of the 5
tables, and in turn, enters the id into the main table.

This worked great for me before, but for some reason, this
time,
when I filter through the combos, goto the next record,
and do
the same thing, the values in the combos for the previous
record
disappear.
However, they are there in the table, just not visible on
the form.

I have each subsequent combo set to Null and requery the
combos
after them.
eg. Me!Combo2 = Null
Me!combo2.Requery,
etc.....
etc.....

the combos that are being requeried have an sql statement
that relates to the previous combo similarto this:
SELECT DISTINCT tblSpecific.id,
tblSpecific.relatedSpecific,
tblRelatedDetails.reportCodes
FROM tblSpecific
LEFT JOIN tblRelatedDetails
ON tblSpecific.id = tblRelatedDetails.relatedSpecific
WHERE (((tblRelatedDetails.reportCodes)=[forms]!
[Form1]![Combo0]))
ORDER BY tblSpecific.relatedSpecific;

In the properties of the SQL I have 'Unique Values' set
to 'yes'
In the format of the Combo box the 'Column Count' is set
to '2'
and the 'Column Widths' are set to '0";2"'

I would like to add that if I set the 'Column Width'
to '0.2";2"' the
values don't disappear. Unfortunately, I would like the
word and not the
number to appear on the form.

This worked great for me before, but I must be overlooking
something this time, and can't figure out what it is.
Any help/suggestions, will be greatly appreciated.

Thank you in advance.