Great - just what I was looking for however I found that the If statement had to all be keyed as a single line for it to work.

Strange really as the MS SQL HELP also formatted the IF as per the example here.....

Now all I need to be find, is how to enquire on a table using ActiveX...:Whistling: