Improve company productivity with a Business Account.Sign Up

x
?
Solved

Enter parameter value

Posted on 2011-09-28
6
Medium Priority
?
219 Views
Last Modified: 2012-05-12
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
Comment
Question by:Frank Freese
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36718275
check the rowSource of your combo box, that is mentioned/listed in the afterupdate event of the combo box "cboEmployee"..

0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36718314
when you find the RowSource of the combo,

change this

Forms!frmAdjustmentsToBonus!cboEmployee

with



Forms!frmMaintenaceToBonus!cboEmployee

btw

should "frmMaintenaceToBonus"  be "frmMaintenanceToBonus"


0
 

Author Comment

by:Frank Freese
ID: 36718350
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 36718361
if i remember it right, check the RowSource of combo cboMonth.
0
 

Author Comment

by:Frank Freese
ID: 36718390
I missed that -- great pick up and thank you - problem gone
0
 

Author Closing Comment

by:Frank Freese
ID: 36718393
thank you - I do appreciate your help
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question