Find & replace in linked field

[Lars Brownies]

Like in the Northwind database I've made a combobox in a table's field. The
field is ID_country but in datasheet/tableview you see the actual
Countryname (which in fact resides in another table). I'm trying to do a
Find & Replace action on this field but I can't get it to work. When I
search on the actual text value, it cannot be found. When I search on the ID
number, it ís found, but the replacement (another ID number) doesn't take
place. When I hit replace Access says the text cannot be found. Can't I use
Find & Replace in this setting or am I doing something wrong? Other options?

Thanks,

Lars

 

[siva Thuraz]

Like in the Northwind database I've made a combobox in a table's field.
The field is ID_country but in datasheet/tableview you see the actual
Countryname (which in fact resides in another table). I'm trying to do a
Find & Replace action on this field but I can't get it to work. When I
search on the actual text value, it cannot be found. When I search on the
ID number, it ís found, but the replacement (another ID number) doesn't
take place. When I hit replace Access says the text cannot be found. Can't
I use Find & Replace in this setting or am I doing something wrong? Other
options?

Thanks,

Lars