Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List Box listindex problem
Message
From
18/12/2001 20:10:37
 
 
To
18/12/2001 19:50:19
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00595827
Message ID:
00595940
Views:
27
>Hello Allen.
>
>>> boundcolumn 1
>columncount 4
>Rowsource customer.name,maillist,addr1,city
>Rowsourcetype 6 - Fields <<
>
>Does it have a ControlSource or is the ControlSource empty?
>
>>> The file is indexed on name+zip (zip is not included in the list) <<
>
>Does the customer table also have a Primary Key? If so, this would be the easy answer. You'd set up your combo like this:
>
>.RowSource = "customer.name, maillist, addr, city, custPK"
>.BoundColumn = 5
>.BoundTo = .T.
>.ColumnCount = 5
>.ColumnWidths = "200, 100, 100, 100, 0" && or something like this...whatever looks good visually
>.ColumnLines = .F.
>
>>> Also I assume I need to do a requery after adding a new record. <<
>
>That is correct. Requery() is how the combo updates its internal list from the underlying data source.

You can just set your column count to 4 and not have to deal with a width for it at all. You'll still have 5 columns (as specified in the RowSource) and can be BoundColumn set to 5, you just never see it.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform