By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,377 Members | 3,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,377 IT Pros & Developers. It's quick & easy.

Getting unique values from a table for a Combo Box

damonreid
Expert 100+
P: 114
Access 2003
Windows XP Pro

Just wondering if there is a quick way to select unique values from a table for a search or for a Combo Box on a form?
Sep 10 '07 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Access 2003
Windows XP Pro

Just wondering if there is a quick way to select unique values from a table for a search or for a Combo Box on a form?
Hi, damonreid.

What about

Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCT .....
Sep 10 '07 #2

damonreid
Expert 100+
P: 114
Tried both without luck, I am sure I am doing something simple wrong, brain isn't working yet I guess...

Ok I was just spelt the field name incorrectly...
Sep 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.