Trying Again...Is this a DLookup case?

[Rich_Lovina]

Whilst this is true in my query & associated words creation, does it mean that I'll have to vary any of your code to take account of all the exceptions?

 

[Fornatian]

This is not a cop-out, but I think that is a quality decision only you can make, do you wish to categorise ONLY when the words are in isolation? or do you want to build a list inclusions suchas...

communication
e-communication
communications

 

[Rich_Lovina]

I'm nearing the end and will run some tests on the exceptions first. To find all the people I want to categorise, I need to be able to pick up:

Communications Cell
Admin & telecommunications
Electronic Communications Systems

i'll run a test

 

[Rich_Lovina]

Ian, Hi there
Ive done the hardyards and have now my tables(470 textwords) in yr dbase sample. Ive changed code where appropriate, but at 1st couldnt get my data on yr form, FrmUpdate.

That being done, I just ran a test. Its functioning but not adding an update on my first test record with str "Test Business".

I'll zip you a copy