Posted on 2000-02-15
Last Modified: 2010-04-04
hello.............well I have a problem.....I have done
a query and the datasource is linked  the Tquery is linked
and my dblookupcombobox is linkede......well
qhen I do the query the rows are on the dblookcombobox but it doesn't
show its there any property or method that makes the dblookuocombobox
to show the rows that i have without the event CLICK
I said ..........some like automatillac selection on the first row

ok bye I hope your reply
Question by:Iamme

Author Comment

ID: 2523146
but I don't speak english very well as you
have seen

Expert Comment

ID: 2523360
mmm, can you give more information?

Which information have you put in DBLookUpComboBox:

DataField, DataSource

KeyField, ListField, ListSource

LVL 27

Expert Comment

ID: 2524173
agree with zif, more info please

if you want a preselect just set the keyfieldvalue as required

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Expert Comment

ID: 2524312
Hi Iamme,

I think I know what you mean, try doing this after you've opened the query:

if DBLookupCombobox.KeyValue = Null then // Only fill when it is empty
  DBLookupCombobox.KeyValue := DBLookupCombobox.ListSource.Dataset.FieldByName(DBLookupCombobox.KeyField).AsInteger;

It think this should do it. Make sure the keyfield is of type integer!

It probably is...

Cheers mate


Expert Comment

ID: 2524316
I've reread your question, you offcourse can also stick in a DBLookupCombobox.ListSource.DataSet.First before my little code snippet.

G'Luck, Mick

Accepted Solution

Freaky earned 50 total points
ID: 2551995

You should set the "listsource" and "listfield" properties to let the combobox show the lines from your query.

Also be sure that the "normal" settings are correct (datasource/datafield)

the data in the "keyfield" is used for the "lookup"



Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now