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()
Private Sub CboMarketNo_Change()
Me.CboDistrictNo = vbNullString
Private Sub CboDistrictNo_AfterUpdate()
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....