Combo Boxes on Forms

[lucy1216]

Let me say that I am not exactly a novice, but nonetheless a beginner.
I had this working in Access 2007 on a singular form, but it is no longer working in Access 2010; however now I am using a tabbed form.
What I am trying to accomplish is to autopopulate a combo box based on a value of another combo box on an unbound form.
ComboBox1:
Row Source: SELECT tblApprovers.[Level 1Approver] FROM tblApprovers WHERE (((tblApprovers.Status)="A")) ORDER BY tblApprovers.[Level 1Approver];
This box is so that an approver can select their name.

ComboBox2: I want this box to autopopulate the total amount due based on the value of ComboBox1.
Row Source: SELECT Sum(qryATT_frmTotals.[SumOfTotal Current Charges]) AS [SumOfSumOfTotal Current Charges] FROM qryATT_frmTotals WHERE (((qryATT_frmTotals.[Level 1Approver])=[Forms]![Form1]![Approver]));


Thanks in advance.

1^st Issue: I am getting a parameter when entering ComboBox2.


2^nd Issue: I want the form to refresh (requery) for results based on ComboBox1 when it’s value changes. I know this should be an AfterUpdate request; however, I am not sure which ComboBox to put the code in; and the code that I am tried is not working.

[orange]

Here are free video tutorials on Cascading Combo. Shows where the requery goes etc.
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html


Your parameter may indicate a spelling mistake.