Re: [MSAccessProfessionals] Form Update

Hi Gib,

Can you provide the Row Sources of your combo boxes? Is this a continuous form or single view? You will have issues on a continuous form if the industry combo box is filtered based on the sector combo box.

You can find some solutions for continuous form combo boxes by searching for "Access Cascading combo boxes continuous form"

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of gib roberts via groups.io <robejohg=yahoo.com@groups.io>
Sent: Tuesday, June 16, 2020 2:34 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [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