retrieve info from field

[yessir]

I have a db where I am trying to automate the import process so that the user only has to press the button basically.

I am having trouble with a part whereby I am trying to find a pattern in one table based on entries in another (maintanence table).

The form I am searching is frmWater_Sample_Import
The code is being tested as command30 button
The recordset is based off of tblWater_Sample_Temp and I am searching the field ClientID
I am comparing the tblWater_Sample_Temp.ClientID to all entries in tblPrefix_Outlets.Prefix
If an entry in tblWater_Sample_Temp.ClientID is like an entry in tblPrefix_Outlets.Prefix then put that part on in the rec("Outlet_ID")

EX:
In tblWater_Sample_Temp.ClientID there is 'HZ250-EN-15'
In tblPrefix_Outlets.Prefix there is 'EN'
Therefore set rec("Outlet_ID") = 'EN-15'

Can Someone Please help with this?

Thanks
~