Combo box/Text box Auto-Populate issue

[rpearson]

I've gone through so many threads trying to find this answer and it's really slowing down my work today, so I've decided to go this route. Thank you in advance for any assistance!

I have 5 combo boxes that all cascade into the next, and then when the last combo box is updated from the drop down list, it auto-populates a text box. My issue is that I have a second text box that needs to be auto-populated from the same data table based on what has been entered into the 5 combo boxes and the first text box. I've tried creating parameters and setting a lookuprecord macro in my main table and then using a returnvars RunDataMacro on the actual form, but it says, "Invalid list or query reference 'BillingDataQuery'." I'm not sure if it's because I'm not setting that RunDataMacro on the wrong combo box, or if I've written it incorrectly...

I did this same technique (based on directions in a post from this forum) on another combo box that populates five text boxes and it works just fine, but I don't know how to get this to work based on what's populated in 5 combo boxes to auto-populate the last text box.

I'm running short on time now and I really need to have this completed before the end of the day.

Help? =)

 

[David R]

Can you post a stripped down copy of the database?

Or perhaps more simply, list the five comboboxes and what their rowsource is.

 

[pr2-eugin]

Hello rpearson, how are you getting the result in the First text box? Are you using the method to Autofill? If so, just add the another column to the RowSource of the ComboBox..

 

[rpearson]

Well, to answer both David and pr2, here are my combo boxes. Please note that apparently I was wrong, I couldn't get the cascade to work properly so 1st filters 2nd, and 3rd filters 4th and 4th filters 5th.

1st - cboInvestor, row source: "CSLA";"CU";"FHA";"FHLMC";"FNMA";"GMAC";"VA"

2nd - cboState, row source: SELECT BillingState.State FROM BillingState WHERE (((BillingState.Investor)=[Forms]![BillingForm]![cboInvestor])) ORDER BY BillingState.State;

3rd - cboBillingDept, row source: "Bankruptcy";"Foreclosure";"Loss Mitigation";"Property Preservation";"REO"

4th - cboBillingType, row source: SELECT BillingType.Type FROM BillingType WHERE (((BillingType.BillingDepartment)=[Forms]![BillingForm]![cboBillingDept]));

5th - cboWorkDesc, row source: SELECT BillingCodes.FeeCode, BillingDesc2.Description FROM BillingDesc2 INNER JOIN BillingCodes ON BillingDesc2.Description = BillingCodes.Description WHERE (((BillingDesc2.Type)=[Forms]![BillingForm]![cboBillingType])) ORDER BY BillingDesc2.Description;

cboWorkDesc auto-populates txtPayeeCodes because there are two columns in cboWorkDesc and the first column appears in txtPayeeCodes using control source =[cboWorkDesc]

Does that help? I was going to strip down the database, but there is some information in those five combo boxes that I can't post in a public forum. =(

Thanks for responding so quickly!