[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 3
1 Solution
 
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
 
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Rey Obrero (Capricorn1)Commented:
if i remember it right, check the RowSource of combo cboMonth.
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now