The cascading combo boxes work just fine in the form CheckRegEntryF when it is opened by itself. It fails when it is loaded as a sub-form.

You need to change your criteria to point to the subform.
Value From Subform

Kathy

When you have comboboxes on subforms, changing the query on the combobox changes it for all comboboxes on all records.

So when you change the query on a combobox, you're probably getting an error because now you have combobox values (in other records)  that do not meet the query criteria of the combobox you're trying to set.

There are a couple solutions for this:

You need to have 2 comboboxes in your subform.  One on top that you can see which has a recordsource of all values.  Then have another combobox behind it that you use to change values for the record you're changing.

When a user goes to change a value in the combobox, it's OnFocus event should set focus to the combobox behind it.  In the AfterUpdate, Set Focus back to the combobox in front.

Run all of your Totals on the displayed comboboxes with all values.

Hope this makes sense.

-Raymond

Kathy

Another Solution:

Do not make changes to comboboxes in the subforms, put them in the form header or footer.

-Raymond

Adam Thank you. I was able to get that part to work.

Raymond I built my cascading combo boxes the way Richard taught in in the Cascading Combo Tech help/Extended cut with the overlaying of a text box. It works just fine until I put it in as a sub-form. I can't put them in the main form because that defeats the purpose of having multiple entries for 1 parent record. A second popup window also defeats the purpose for data entry.  There has got to be a short piece of code that I am missing to make this work. I'm sorry but, your explanation confuses me.

Kathy

Rick built his on a Single Form.

What I was trying to tell you is that you can't update the recordsource for a combobox in Continuous Form without it affecting the combobox of every record.

-Raymond

Kathy

Example:

Form Details Section:
====================================
Record     ComboBox(State)     ComboBox(County)
1               Texas                           Foard County
2               Florida                         Marion
3               Ohio                            Brown
4               New York                     Queens
====================================

The ComboBox(County) for Record Source 1 is set by ComboBox(State)

If you Select Florida in ComboBox(State) on Record 2... the ComboBox(County) for every record gets changes.
-This makes the combobox value in Record 1, 3 and 4 all invalid values.  

This is why you're getting the error, which I tried to explain in my first post.

You have to implement the solution I gave you for it to work.

-Raymond

Raymond Unfortunately, I am a visual learner. I need more specific information than what is being provided. What you are explaining with the State/County combos is not what is happening on my form. When my form first loads (before I even have a chance to enter any data) the enter parameter value box pops up. If I enter a value, say 1 for Business, the Account box fills just fine and the Category box loads. When I move to the next line to add a new record in the sub-form, the Account box has all my options but when I select one, the enter Parameters box pops again. If put a value i it, say 3 for Dues, the Category Box loads the correct information and does not bother the record above it.

Kathy When cascading combo boxes are used in a subform, your form reference needs to refer to the parent form as well.  E.g.:

      [Forms]![ParentFormNameHere]![CheckRegEntryF].[Form]![AccountCombo]

If you want to make CheckRegEntryF work as a stand-alone form again, you need to change the form reference back to:

      [Forms]![CheckRegEntryF]![AccountCombo]

If you want to do the switch automatically (instead of manually switching every time), you need some VBA trickery.  You need to use VBA to check if CheckRegEntryF has a parent form.  If it does, it is a subform.  A subform's parent form is referred to as Parent in VBA.  E.g.:

      Debug.Print Parent.Name     ' This prints the name of the parent form.

If it doesn't have a parent form, the above code returns an error.  So you need to use On Error to check if Parent exists or not without causing an error:

Sub MySub()
     On Error Goto NoParent
     Debug.Print Parent.Name
     On Error Goto 0
     ...
     Exit Sub
NoParent:
     ' If this line is run, parent doesn't exist - stand-alone form
     ...
End Sub

Kevin Thank you! I knew it had to be something simple. I have made that change and it works great. There should never be a time when the CheckRegEntryF is used by itself but I appreciate the heads up about needing to change it and how I would do that. You guys are all awesome to take your time to help. I truly appreciate it.

Kathy  The problem Raymond mentioned affects subform combo boxes with hidden bound columns, which seems to apply to you from your screenshots.  This is something to watch out for as well.  (In my old job, I just avoided this kind of combos in my subforms.)