>Hello UT,
>I have a form which contains a combobox that is populated with an Sql statement(rowsource type = 3):
SELECT cbranch_name, branch FROM branches ORDER BY cBranch_name INTO CURSOR cBranchList
>This Select statement returns about 50 recors. On my combobox ( when I append a new record) I want to display a specific record from the cBranchList.
>For example if I go to this form and I belong to a branch named
"Miami" then when I append a record I want to default the combobox to display "Miami".
>Any help is appreciated.
I think it's just matter of issuing the thisform.mycombo.requery().
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!