B
Bill Mitchell
I have an append query where I am trying to append the
value of a calculated control on my form to a field on a
table. Sounds simple enough. If I base the calculated
control on the column of a combo box like:
=forms![Main]![MyCombo].column(1)
it works just fine.
However, if I base the control on just another field like:
=forms![Main]![ContactID]
my append query just returns weird boxes and Chinese
Characters. Funky. Have checked data for corruptions
and see none. Have compacted and repaired.
If I use = Dlookup("[ContactID]","Contact","[ContactID]
=forms![Main]![ContactID]") in my query, it also works.
It only doesn't work when the calculated control is just
giving me the value of another control.
How bizarre. Any help out there?
Bill
value of a calculated control on my form to a field on a
table. Sounds simple enough. If I base the calculated
control on the column of a combo box like:
=forms![Main]![MyCombo].column(1)
it works just fine.
However, if I base the control on just another field like:
=forms![Main]![ContactID]
my append query just returns weird boxes and Chinese
Characters. Funky. Have checked data for corruptions
and see none. Have compacted and repaired.
If I use = Dlookup("[ContactID]","Contact","[ContactID]
=forms![Main]![ContactID]") in my query, it also works.
It only doesn't work when the calculated control is just
giving me the value of another control.
How bizarre. Any help out there?
Bill