Hi i am trying to write something that would alert an inputter to the fact that a record for a id no already exists, i only want to make a warning as sometimes the same id no may have mulitple events

the field name is hospno and the table "personal details" an id no would be along the lines of v653

I found this code to put into the before update event on the field in an access form but it just give me a runtime...