Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox
Message
From
30/12/2000 12:43:27
 
 
To
30/12/2000 12:24:53
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00458087
Message ID:
00458101
Views:
22
Hi Steven,

Do you have a requery in the code for you listbox? I was able to duplicate the problem if I ommited the requery.

mcF2Val=thisform.text1.value
ThisForm.List1.RowSource = "Select table1.field1 From table1 Where field2=mcF2Val InTo Cursor mycursor"
thisform.list1.requery()
thisform.refresh

Bill

>Bill,
>
>The listbox is populated with an sql statement:
>
>witmv = AllTrim(ThisForm.Text1.Value)
>ThisForm.List1.RowSource = "Select seatno From seat1 Where modelno = witmv InTo Cursor myseatlist Order By seatno"
>ThisForm.Grid1.RecordSource = ""
>ThisForm.Refresh
>
>This is done in a method of the form.
Bill Leber
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform