Cascading Combo Box - How to save selected item?

[CJ_London]

I am storing the SectorType (Corporate or Operational)

your cbxSectorType is bound to the ID so it is storing the ID not the type

Other issues - the control source to cbxSectorType is SectorType, but in your recordsource you are bringing through DATA.[Sector Type]

How to fix that?

correct the typing

I cannot see the codes. In After Update, I clicked [...] then selected Macro Builder. Then from the list, I picked "Requery" and then I inputted the control Name "CbxSector".

then you need to do the same for the form current event.

[Pascale]

If I remove SectorTypeID from the followings, the "list" of sector types do no show any longer for that field. But it seems to work fine in this way. It is the Sector field that does not work (i.e. does not show on the form although it now saves in the table)SELECT TblSectorType.TblSectorTypeID, TblSectorType.[Sector Type]
FROM TblSectorType
ORDER BY TblSectorType.[Sector Type];

[Pascale]

Everything now works fine!!!! Thank you sooooooo much! I had been desperately googling this for weeks... Maybe you could post a little video on how to create simple cascading comboboxes. You are the best!!

[CJ_London]

I usually refer users to http://www.access-programmers.co.uk/...d.php?t=275155

which is intended for continuous forms/datasheets, but works in single forms as well. Your setup as it stands will only work in single forms.

[Pascale]

Thanks. I would like to mark this thread as solved but cannot find how. I clicked the "How to Mark a Thread Solved" tab above but it does not work...

[CJ_London]

near the top on the right of the green bar, click on Thread Tools