Without looking at the actual database, I can only ask rather generic
questions. What version of Access are you using? Are all of the Service Packs
and HotFixes applied?

Kathryn wrote:
Hi - sorry for the delay in getting back to you - it's been a bit manic with
the other side of my work this week!

To answer the question - no, I didn't put the code in. I used the Contacts
Management template as the basis of our own and up until last week it worked
fine. To be honest, I hadn't checked what code was there as I'm so new I
wouldn't have known how to! I've learnt a lot but can't say whether it
changed from one day - when it worked - to the next when it didn't

Not much help I know but hopefully you can prompt what other information you
might need.

Many thanks

Hi Kathryn,
Did you put that code in the ControlSource of the TextBox?
[quoted text clipped - 22 lines]

Many thanks

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com