Hey Guys,

Anyone would be able to offer a newbie some help. I would most appreciate it. I am trying to work on a project where my company has Markets/Districts/Branches. I have created three seperate tables and also built the desired relationship. I am having trouble with the code... I can navigate from Markets to Districts, but my final step on Branch's combo box does not display the final branch results... Any ideas?

Option Compare Database


Private Sub CboMarketNo_AfterUpdate()
Me.CboMarketNo.Requery
End Sub

Private Sub CboMarketNo_Change()
Me.CboDistrictNo.Requery
Me.CboDistrictNo = vbNullString
End Sub

Private Sub CboDistrictNo_AfterUpdate()
Me.CboBranchNo.Requery
End Sub

Look here

Access Tips: Cascading Lists for Access Forms

alansidman,

Thanks for the prompt reply! I have been working on this database for a few days now and pretty much making it work. The only thing I am confused on is the fact that the Tables are being displayed on each drop down menu correctly, but somehow it retains the first value on the list on the two subsequent combo boxes. I don't seem to get it to work, so that the value I choose is fixed throughout the form. Please help....

Krico