Re: [MSAccessProfessionals] Form Update

That was it!

Did "Requery" "On Entry" to the industry combobox and it now up dates the form.

Thanks

Gib

On Tuesday, June 16, 2020, 9:13:20 PM GMT-3, Arnelito Puzon <agpuzon@gmail.com> wrote:

add Code to the Form's Current event changing the RowSource of your combo to show All

records from Industry table.

add Code to the sector combobox (AfterUpdate event) to change the Rowsource of the 

industry combobox to only show records on same Sector.

On Wed, Jun 17, 2020 at 7:33 AM Duane Hookom <duanehookom@hotmail.com> wrote:

Hi Gib,

A continuous form shows multiple records at a time while a single shows only one. This is a form property you set in design view.

You might only need to run a little VBA code in the On Current event to requery the industry combo box.

Regards,

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 4:25 PM
To: msaccessprofessionals@groups.io <msaccessprofessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Form Update

 

Duane,

Thanks for the quick reply!

The industry combo box is filtered by the selection in the sector combo box.

I am not sure I understand "continuous and single view". This form will only address one record at a time from tblSymbol. 

I will look for "Access Cascading combo boxes continuous form" and see if I can figure it out.

Thanks again for you help.

Gib

On Tuesday, June 16, 2020, 5:16:54 PM GMT-3, Duane Hookom <duanehookom@hotmail.com> wrote:

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

--

Arnelito G. Puzon