Hello,
When opening the database there is the Main Form. The Clerk button is for entering new records (password "clerk"). On that form there is an AFR Number field. Is there a way to popup a message there if the user enters a previous AFR Number? I'm not sure if this will conflict with searching for AFR Numbers on the other forms: Administrator (password "admin"), Technician (password "tech") or the Research form (no password).
I appreciate the help,
Bill