Populate Access ListBox with Distinct/Unique Values

[globz]

I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "lstCateName" displays a property type (castle, villa, manor) from a table named "tblProperty" on a form called "frmType".

My problem is with getting the ListBox to display only one of each Property type (Only 3 options instead of many same repeating options like in the image below)

I need it to only display 3 options, "castle", "villa", and "manor". I have looked endlessly for the solution to no avail. There are some tutorials out there that focus on Excel and use VBA which i am not familiar with nor do i know how to implement into an Access Database.

 

[hernantorres23]

Hi, in Access is easier than Excel, you only use RowSourceType property to Table/Query and its RowSource property put the query with Select Distinct Type From tblProperty

Please see this post:

Search Query In Access

Morning all, just after a bit of help with an access query. I have one table with customer data on. I also have a form with text boxes which colleagues type into and it writes to the table. that works ok. I am trying to now create a search so people can go in and see how many times a...

www.mrexcel.com