Find & Replace

[prabhus]

Is it possible to have a Find & Replace in the table using access forms. ( Like the inbuild option in Excel ), I want the user to search some data & replace with the new data which may present in more than one record.
I want to do it with forms, because i dont want the user to use the tables.

 

[CJ_London]

In the form, the user just needs to highlight the relevant field and hit ctrl-H to bring up the replace prompt.

 

[prabhus]

But when same data repeates in many records, i want to select all those data's and replace at one time.

 

[Mihail]

But when same data repeates in many records, i want to select all those data's and replace at one time.

Depending of your data you can use Update queries (google for more information) or to use the recordset object: Recordsets for Beginners - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com