Hi all,
We have a listbox that's being populated by an SQL command. We want to click on a record in the listbox to populate the rest of the form with data based upon which record was chosen. When the code to do this is in the Click event, it does not work. Even though the record is found (found()=.t.), it still jumps to the first record in the table being searched. But when the code to do this is placed in the DoubleClick event, it works perfectly. Also, when the code is placed in a Command Button, it works perfectly (clicking on the desired record, then clicking the Command button).
Any ideas what could be wrong here?
Thanks very much,
John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi
* All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please.
* Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC.
©2007 John J. Mihaljevic |