change same field in multiple queries

[velveeta]

I currently have a unique ID# in a table, with many other queries and tables attached to it. When I change the unique ID I have to change it in about 10 different queries to make sure it updates all the necessary tables.

I want to enter some code or use a macro that, once I decide I am going to change the unique identified in the main table, will replace the id# field in each query with a replacment ID# (search for a ID#1 and replace with ID#2 in any of these 10 queries, only IF that ID#1 is present in the query). I can use code or a macro if possible.

 

[SkipVought]

Hi,

Format a dynamic SQL string
[code[
sql = "Select A.* From MyTable A Where A.ID='" & MyID & "' "
[/code]


Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]