Calling more than one query

[essential]

Could I use an if statement with say

[b]goto location_id if contains "ecen" goto location_id_2 [/b]

If this is possible could I also add

[b]if location_id_2= ecen goto location_id_3 etc[/b]

I have tried tweaking the recordset but it just throws up an error.

Recordset below

[b]SELECT autonumber, coName, location_id
FROM preferredSuppliers
WHERE location_id = 'ecen'
ORDER BY coName ASC[/b]

How easy would it be to alter this to give me what I need

Essential