I tried changing the code to:
Private Sub EmployeeName_OnChange()
Me.AccountListing.Form![EmployeeName].Requery
End Sub
Private Sub AccountID_OnChange()
Me.AccountListing.Form![AccountID].Requery
End Sub
Private Sub AccountName_OnChange()
Me.AccountListing.Form![AccountName].Requery
End Sub...
Hi,
I have 3 unbound items on a form. Each one depends on another. The first one is called Employee Name, the second one Account Name, the third Account ID. I have it so that the users select an Employee and then they choose from a list of Account Name associated with that Employee name and...
Hi,
I tried that and I have entered:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 2279 Then
MsgBox "Please enter the infraction date in the following format: MM/DD/YYYY", [vbokayonly], [Date Error]
Response = acDataErrContinue
End If
End Sub
However...
Hi,
I have an input mask:00/00/0000;0;_ for users to enter date.
I also have a validation rule that it cannot be a date greater than today's date.
The validation text will only show up for if the validation rule is violated but will not show up when users don't enter the data according to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.