I've been working with this all day and have your design integrated pretty well, thanks again. One thing I can't figure out is that some of the Location 3 data (SubSubLocation) doesn't remain in Table1. It seems that if I update a record with Location 3 data, it deletes the information from the previous one. A similar thing occurs on sample you passed along too, so I am having a hard time troubleshooting. Here is the VBA, does anything jump out at you? (It's a bit too complicated for me to breakdown!!)
Code:
Option Compare Text
Option Explicit
'Private Sub cboLocation_AfterUpdate()
' Me.cboSubLocation.Value = 1
' Me.cboSubSubLocation.Value = 1
' Me.cboSubSubLocation.Requery
' Me.cboSubLocation.Requery
'End Sub
Private Sub cboLocation1_AfterUpdate()
Me.cboLocation2 = 1
Me.cboLcoation3 = 1
Me.cboLocation2.Requery
Me.cboLcoation3.Requery
' Me.cboSubLocation.Value = 1
' Me.cboSubSubLocation.Value = 1
End Sub
'Private Sub cboSubLocation_AfterUpdate()
' Me.cboSubLocation.Value = 1
' Me.cboSubSubLocation.Requery
'End Sub
Private Sub cboLocation2_AfterUpdate()
Me.cboLcoation3 = 1
Me.cboLcoation3.Requery
End Sub
And if you've seen enough of this project and want to just move on, I completely understand!!