Combo Box Problem

[Creeder]

Hi all,

I have this following table,

Table : Company
Column: Name, Alias, Company_id

I then assigned the rowsource of the combo box to this table, displaying the 3 columns in the combo box.

The Problem:
Let's say if i do a search on the Alias and company_id,eg

Locate FOR Alias = 'ALD' AND Company_id = 5

and when FOUND() = .T., how do i dynamically change the display value in the combo box?

I've tried Requery() but it's not working. Any help is greatly appreciated.

Thanks

Yue Jeen [sig][/sig]

 

[foxdev]

If the RowSource is the table, you could try Refresh(), but I don't think that will work. You'll probably need to add code to the end of your LOCATE section that sets the ComboBox.Value to the value matching the found record (depending on which ComboBox column is the BoundColumn). [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[Creeder]

Yeap it works. Coding something like

LOCATE FOR ....

IF FOUND()
THISFORM.combo1.Value = <value>
ENDIF

solves the problem. Thanks again for the instance response foxdev.

Yue Jeen
[sig][/sig]