Field in Relationship Loses BackStyle When Filtering Records

[JamesJ]

Access 2007.
This is driving me crazy and I'll have a difficult time explaining, but here
goes.
Using a one-top-many between 2 fields:
tblProductType.ProductTypeID (Left Column)
tblHomeInv.ProductTypeID (Right Column)
I have several other relationships with the same results. The odd one out
is a relationship that I deleted and made several other changes to and
this anomaly doesn't occur now. I haven't the slightest idea what I did
to correct the problem. Inpatients got the best of me.
The ProductTypeID in tblProductType is set up as a cbo to select the
Product type forth record. his form is similar to a split form with a
list box on the left side and the editable data on the right.(Including
tblHomeInv.ProductTypeID.
These relationships are used to filter records from a combo box based on
tblProductType.
Here' what happens:
After making a selection in the cbo and running the code from the
AfterUpdate
of the cbo the records get filtered properly but, what appears to be the
Backstyle of
tblHomeInv.ProductTypeID becomes Transparent even though the property is set
to Normal.
The odd thing is this doesn't occur when the BackColor of the Detail Section
of the form
is White, only when the Backcolor of the Detail Section set to a color other
that white.
I hope I've made my self clear?

Any help will be appreciated,
James

 

[Allen Browne]

James, I have this problem also.

A very ordinary combo (bound to a field, RowSource is a lookup table), goes
transparent after I visit it (i.e. tab into and out of it.)

I haven't tried to track down why, but there's no obvious reason. The combo
is in the Detail section, and the section has a blue background.

 

[JamesJ]

I'll keep digging.

Thanks much,
James

James, I have this problem also.

A very ordinary combo (bound to a field, RowSource is a lookup table),
goes transparent after I visit it (i.e. tab into and out of it.)

I haven't tried to track down why, but there's no obvious reason. The
combo is in the Detail section, and the section has a blue background.