I get the subject run time error when I try to past a record. The error reads:
"The value you entered doesn't meet the validation rule defined for the field or control."
Then it takes me here in the VBA:
Private Sub cboEmployee_AfterUpdate()
Me.RecordSource = "qryHours"
Me.Refresh
End Sub
More info:
The form I am using is a continuous form. The record source for the form is "qryHours". The combo box "cboEmployee" is a drop down they use to select their name, which updates the form with the hours they have logged into the system.
Because the projects they work on are the same from week to week they would like to copy and past records, making keeping track of their time less time intensive.
Any ideas?
"The value you entered doesn't meet the validation rule defined for the field or control."
Then it takes me here in the VBA:
Private Sub cboEmployee_AfterUpdate()
Me.RecordSource = "qryHours"
Me.Refresh
End Sub
More info:
The form I am using is a continuous form. The record source for the form is "qryHours". The combo box "cboEmployee" is a drop down they use to select their name, which updates the form with the hours they have logged into the system.
Because the projects they work on are the same from week to week they would like to copy and past records, making keeping track of their time less time intensive.
Any ideas?