Control on Multipage Form

[taylornow]

I have a multipage form with quite a bit of info that needs to be entered. The employeeID is set for no duplicates due to the fact that many people enter data from different sources. Is there a way to notify them it is a duplicate before they are at the end of the form? Is there a way to set a contol on the EmployeeID field that will tell them when they tab to the next field instead of at the end ?

Thanks in advance
Taylor

 

[Rohdem]

As I said on your last post, you can try to save the record immediately after the EmployeeID field is updated, which will cause an error if there are duplicates, letting the user know that the EmployeeID already exists.

Private Sub EmployeeID_AfterUpdate()
DoCmd.RunCommand acCmdSaveRecord
End Sub Mike Rohde
rohdem@marshallengines.com

 

[taylornow]

Thank you. I apologize for missing the first response you gave me.

Taylor

 

[KarMac21]

You could use code like this:

Private Sub txtEmpNo_LostFocus()
If Not IsNull DLookUp("EmployeeID","YourTable","[EmployeeID] = '" & txtEmpNo & "'&quot then
msgbox "Employee ID already exist",vbInformation,"Duplicate Employee ID"
txtEmpNo.SetFocus
end if
end sub

Hope this works - Shane