Thanks for your help mancubus. I would hope to be able to prevent folks from missing data with the help of vba and messageboxes, which I would hope would"hold the users hand" throughout the process of entering data. This would at least ensure no important information is missed or the original person having to be found to account for missing data.

If it cannot be done through VBA at least I can look at alternatives or abandon it.

So if anyone who is in the know thinks it can't please say. At least then I have taken solid advice from an expert.

Thanks