[MSAccessProfessionals] Form Update

I am new to this so please bare with me.

I have three tables:
tblSymbol                  tblSector       tblIndustry
SymbolID                     SectorID         IndustryID
txtSymbol                     txtSector         txtIndustry
txtSymbolName                                   intSectroID
intSectorID
intIndustryID

I created a form in as attempt to enter Symbol and Symbol Name; with a combo box for Sector and combo box for Industry based on Sector selection.
This works when I enter the data. The correct txtSector and filtered txtIndustry are available in the combo boxes.
The correct SectorId and IndustryID are entered in the tblSymbol.

However, when I return to a previous record on the form, the Sector is correct but the Industry is blank. In fact, in all but record 1 are blank

When close and reopen the form I get the same results.

Any help is appreciated!

Thanks
Gib

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115610) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_