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