Settling Synconized combo boxes to keep their values on new records

[cchampagne17]

Hello,



I've found myself in quite the perdicament.. I have 2 combo boxes in a form. One combo box has a list of categories, while the second bombo box is synconized so that it pulls the category selected's coresponding subcategories from it. The rest of the boxes in my form are not synced and I've programmed them to keep their value if someone makes a new record.

I used the same code (the one that tells the combo boxes to retain values) that I used for the other combo boxes on the synconized combo boxes. However only the category box stays the same, and the subcategory is empty and I have to re-select the category inorder to get the list of corresponding subcategories. Is there any way that I can get box boxes to retain their values in new records until someone has to manually change it? Because right now I'm having a lot of problems figuring it out...

This is the code I used for a box to retain its previous value in a new record...

Private Sub Combo76_AfterUpdate()
Me.Combo76.DefaultValue = """" & Me.Combo76.Value & """"
End Sub

This is the code that sorts the subcategory box to select the subcategories that correspond with the selected category...

Private Sub Combo70_AfterUpdate()
Me.Combo72 = Null
Me.Combo72.Requery
Me.Combo72 = Me.Combo72.ItemData(0)
End Sub

I've tried removing the "null" from the code but that doesn't do anything...

[June7]

Are these comboboxes in a Continuous or Datasheet view form? Is the second combobox a multi-column with lookup alias? Dependent comboboxes with lookup don't act nice in those forms. This is a common topic and has been discussed in this forum.

[cchampagne17]

Are these comboboxes in a Continuous or Datasheet view form? Is the second combobox a multi-column with lookup alias? Dependent comboboxes with lookup don't act nice in those forms. This is a common topic and has been discussed in this forum.

The combo boxes are in continuous view form. Sorry for the confusion. Combo70 is the combo box for the broader categories while Combo72 is the second combo box that looks up the corresponding subcategories for the general category selected in Combo 70.

[cchampagne17]

Are these comboboxes in a Continuous or Datasheet view form? Is the second combobox a multi-column with lookup alias? Dependent comboboxes with lookup don't act nice in those forms. This is a common topic and has been discussed in this forum.

I actually figured out how to do it. It turns out that I had an extra requery code written in that cleared the subcategory box each time a new record was created even though I was using the code that makes the combo box retaining the values... Clearing that extra requery code made it so that the subcategory combo box stayed the same for each new record.

Thank you for your help!!