N
NewAccessUser
Hi All!
I have a data entry form for a table (tblProject) that contains all its
fields. On this form, I have a series of combo boxes for Project Location,
where its record source is another table (tblLocation), where a list of all
regions, provinces and cities can be retrieved and can be selected by the
user through the combo boxes. Each combo box is linked to tblLocation table
via the LocID field. Through table/query, I can successfully display the
list of regions, provinces and cities per combo box by hiding the LocID
(setting its width to 0â€) and displaying only the desired field. My problem
is how can I display unique values for Region and Provinces in the combo box?
Using SELECT DISTINCT tblLocation.LocID, tblLocation.Region FROM tblLocation
or SELECT DISTINCT tblLocation.LocID, tblLocation.Province FROM tblLocation
does not do the trick.
Format of data in tblLocation are as follows:
LocID Region Province City
1 I A City1
2 I A City2
3 II B City3
4 II C City4
and so on.
Any suggestions? Anyone?
Thank you
Nadz
I have a data entry form for a table (tblProject) that contains all its
fields. On this form, I have a series of combo boxes for Project Location,
where its record source is another table (tblLocation), where a list of all
regions, provinces and cities can be retrieved and can be selected by the
user through the combo boxes. Each combo box is linked to tblLocation table
via the LocID field. Through table/query, I can successfully display the
list of regions, provinces and cities per combo box by hiding the LocID
(setting its width to 0â€) and displaying only the desired field. My problem
is how can I display unique values for Region and Provinces in the combo box?
Using SELECT DISTINCT tblLocation.LocID, tblLocation.Region FROM tblLocation
or SELECT DISTINCT tblLocation.LocID, tblLocation.Province FROM tblLocation
does not do the trick.
Format of data in tblLocation are as follows:
LocID Region Province City
1 I A City1
2 I A City2
3 II B City3
4 II C City4
and so on.
Any suggestions? Anyone?
Thank you
Nadz