Cascade validations

[Access is tough]

Hi Guys

I am struggling with cascade validations.

I am new to access and want to build a tracker for documenting work progress.



What it involves is in a form - if region is selected as Singapore - only clients of Singapore region should be seen.
(see attachment)

How do I do that, I've tried but can't find a step by step approach to this problem?

Kind regards

[June7]

First off, shouldn't Clients be a combobox instead of textbox?

Possible RowSource sql: SELECT ClientID, ClientName FROM Clients WHERE Country = [cboCountry];

Then code in combobox GotFocus event: Me.cboClient.Requery

Cascading combobox is common topic.

[isladogs]

Here's an example with 5 cascading combos from my website: http://www.mendipdatasystems.co.uk/c...xes/4594455723

And another from the FMS site: http://www.fmsinc.com/microsoftacces...cascading.html . However, I've not used that myself & apparently it has some flaws.