Reading other posts I've got bits and pieces of what I want to do but can't figure out the easiest most user friendly way to do it.
I have a primary field named blgd#. When a user is entering data the building number may already be listed in which case they would get the "change not successful because it would create a duplicate" message. They will have no idea what that means.
So I'm not sure if I could
There would be too many records to have them scroll through the whole list to see if the building number exists already.
- put a filter on the form so as they type the building number in the field the record will come up in a list, (I think would be most user friendly but by other posts it sound very complicated to do)
- or have a pop up form where they enter the building number which runs a query that would look to see if the number exists, (I would think with this you would have to have an if statement so if there is no record it opens a blank but if there is it opens that record)
- or when there is a duplicate have the Find option pop up,
- or have Find pop up when the form is open.
Any suggestions on what would be best or if there is a better way to do it?