header
asked on
Use Combo box like MS Access 2000
I am trying to convert from MS Access 2000 and am running into a small problem with the combo boxes in Delphi. In access if I have an employee maintenance form and on that form is a status field that has a combo box filled with (Active, Inactive, ect.) it is set up by telling the combo box where to get it's list and the column properties and then telling it what data field on the form to be bound to.
However, I haven't found out how to duplicate this behaviour in Delphi yet. I can get the combo box to bind to the status field correctly, but how do I get it to populate with the valid options (They are in a table) and how do I get it to display multiple columns?
However, I haven't found out how to duplicate this behaviour in Delphi yet. I can get the combo box to bind to the status field correctly, but how do I get it to populate with the valid options (They are in a table) and how do I get it to display multiple columns?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, I forgot about this question.
Thanks!
Thanks!
Use a DBLookupComboBox(included with delphi). ListSource property is data source and set ListField and KeyField to the field you want to display in drop down.
or you can look on this website,they have alot of free DBLookupComboBox's with different features,Just in case the DBLookupComboBox included with delphi dosent have enough features that you want:
http://www.torry.net/db_lbcb.htm
Good Luck :-)