String edit/replace one record at a time.

[Patrick1]

Greetings,
Is there a way to do an string Edit>replace All but have it only work in a single record. I find that the replace all goes to all records and I can't seem to limit it to the current record. There are multiple occurences of the replacement in the current record so I know I can use the Replace one at a time option, but the whole record would be easier.

Thanks
Pat Thanks,
Patrick
phmurphy@aol.com

 

[hermanlaksko]

Hi Patrick
You couls do this via a me!recordsource= "Select * From YrTbl Where YrID=" & me!YrfldID
This would select one record and only this one would be edited.
Herman