Distinct Values in Combo Boxes

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
 
C

Cege Anderson

Hi

Guess one way could be to let the query that you base you combo box upon to
only show unique values.

Guess there are other ways as well.

Best regards
Cege Anderson

"NewAccessUser" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top