Solved Dlookup to prevent duplicate entries

[donkey9972]

Well, the data being reported up is all about date specific. There is essentially nothing else tying the data together. I might just be in a unique situation where the date has to be the primary focus. The form BeforeUpdate event does not work correctly for me as far as I can tell. However, I have decided on a new course of action which is solving my issue. I have removed the requirement for the date to be required. Turned it to no. I have decided to disable all controls on the form except the date until a date is entered. Once the date is entered, they become enabled. Its a workaround, but it solves my issue I was having. Thank you all for the help and the chance to learn some things.