Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

that is possible...??

Status
Not open for further replies.
bigdad

bigdad

Programmer
Jul 17, 2001
34
VE
I have a combobox and its data is coming from a table. now I want know if is possible that I can filter this data and the result showit in this control. I tried with some code but nothing...

thanks for your help

Bigdad
 
Sort by date Sort by votes
Hello Bigdad!

Yes, this is very possible. Set the RowSourceType property of the combobox to 3-SQL Statement and then enter an SQL SELECT statement into the RowSource property to filter the data you need from your table.

Good luck!
-- michael~
 
Upvote 0 Downvote
You can also do it if your RowSourceType is set to Alias or Fields by setting the filter of the source table with the SET FILTER TO command.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Locked
  • Question
Change report title/header - is it possible?
Replies
8
Views
432
SitesMasstec
SitesMasstec
kiyo
  • Question
Class definition EXCEL.APPLICATION is not found. 2
Replies
11
Views
722
trial03
trial03
MathiasB
  • Locked
  • Question
Check outlook is running
Replies
4
Views
665
Chris Miller
Chris Miller
Mandy_crw
  • Locked
  • Question
property showwindow is readonly error 3
Replies
6
Views
1K
Chris Miller
Chris Miller
Sydney Savoy
  • Question
"Printer not ready", but client is not trying to print
Replies
9
Views
416
tomk3
tomk3

Part and Inventory Search

Sponsor

Back
Top