G
gt
I made a very careless mistake and since it was with a
field that is not queried very often it hadn't come up
until 1000 records later. I have 2 forms that write to the
same table but with slightly different prompts. I have a
combo-box to display a list of Equipment based on a query
to filter on EquipType. For example; SELECT [tblEquipment].
[EquipID], [tblEquipment].[EquipName], [tblEquipment].
[EquipType] FROM tblEquipment WHERE ((([tblEquipment].
[EquipType])="HpMicro")); and bound it to Column1. But on
the other form I didn't select EquipID in the row source
query. So now some of my data has 3 as the value and the
other has LSink1, both referring to the same record in the
combo-box source. Is there a quick way to clean my data so
that the value stored is the same when referring to the
same record in tblEquipment.(of course I'll fix my form as
well). Thanks for the assistance.
field that is not queried very often it hadn't come up
until 1000 records later. I have 2 forms that write to the
same table but with slightly different prompts. I have a
combo-box to display a list of Equipment based on a query
to filter on EquipType. For example; SELECT [tblEquipment].
[EquipID], [tblEquipment].[EquipName], [tblEquipment].
[EquipType] FROM tblEquipment WHERE ((([tblEquipment].
[EquipType])="HpMicro")); and bound it to Column1. But on
the other form I didn't select EquipID in the row source
query. So now some of my data has 3 as the value and the
other has LSink1, both referring to the same record in the
combo-box source. Is there a quick way to clean my data so
that the value stored is the same when referring to the
same record in tblEquipment.(of course I'll fix my form as
well). Thanks for the assistance.