Enter parameter value

Experts,
I have a combo box that generates the following error in he AfterUpdate event:
Enter Parameter Value
Forms!frmAdjustmentsToBonus!cboEmployee

The name of the form is frmMaintenaceToBonus

The query is:
SELECT tblAdjustmentsToBonus.EmployeeID, tblEmployee.EmployeeFirstName & " " & [EmployeeLastName] AS Employee
FROM tblAdjustmentsToBonus INNER JOIN tblEmployee ON tblAdjustmentsToBonus.EmployeeID = tblEmployee.EmployeeID
GROUP BY tblAdjustmentsToBonus.EmployeeID, tblEmployee.EmployeeFirstName & " " & [EmployeeLastName];

I cannot locate this source
Frank FreeseAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
if i remember it right, check the RowSource of combo cboMonth.
0
 
Rey Obrero (Capricorn1)Commented:
check the rowSource of your combo box, that is mentioned/listed in the afterupdate event of the combo box "cboEmployee"..

0
 
Rey Obrero (Capricorn1)Commented:
when you find the RowSource of the combo,

change this

Forms!frmAdjustmentsToBonus!cboEmployee

with



Forms!frmMaintenaceToBonus!cboEmployee

btw

should "frmMaintenaceToBonus"  be "frmMaintenanceToBonus"


0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Frank FreeseAuthor Commented:
the query I listed above was from the row source. By the way, this is a copy of the form you fixed for me on post 36598961. All I did was copy the orginal form frmAdjustmentsToBonus and named the copy frmMaintenanceToBonus ans deleted in the new form the command button Maintenance.
0
 
Frank FreeseAuthor Commented:
I missed that -- great pick up and thank you - problem gone
0
 
Frank FreeseAuthor Commented:
thank you - I do appreciate your help
0
All Courses

From novice to tech pro — start learning today.