Removing Certain Entries From Text Field

[NAP50]

I currently have an access form which contains a text field named “emails”. The text field is populated by a query which returns entries from an sql database (specifically it is from an sql view created in Microsoft SQL server 2008).

What I urgently need to do is remove entries relating to test emails such as testaccount1@email.com, testaccount2@email.com etc. Is there any way I could do this using VBA code, perhaps after the code to populate the text field has finished?

If so what should I be looking into?

[ranman256]

build a make table query, create a local email table to use. tEmails
delete items in this list you dont want, then use this list to send.

[NAP50]

That worked, thanks for the suggestion Ranman.