Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo Box....
Message
 
To
29/04/1998 13:54:57
Travis Clark
Journal Record Publishing Co
Oklahoma City, Oklahoma, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00095706
Message ID:
00095750
Views:
21
>Per your suggestion, I have combined both forms into one, using page frames. Okay, but I am still lost on how to create a bond where the combo box decides on the output of the rest of the form (which are text boxes.)

For example (very general):
Combobox items:
Apple
Orange
Grape
Cherry
Melon

*Orange was selected in combo

*Combo.InteractiveChange()
select myListTable
set filter to myField = this.DisplayValue
go top in myListTable.
thisform.pgfPageFrame.ActivePage = 2 && show your list page or you can switch manually then
thisform.pgfPageFrame.Page2.Refresh()
*

If you want to display multiple records textboxes are not the easiest way to do this because you have to have also navigational buttons to move through your filtered table and on each SKIP refresh the page - better use listbox, or grid with RecordSource = myListTable

I would prefer to use the grid with RecordSource = myListView where myListView is a parameterized view, something like
SELECT fruits.Code, fruits.Name, fruits.Price FROM fruits WHERE fruits.Code = ?myValue

*Combo.InteractiveChange()
myValue = this.DisplayValue && or myValue = this.Value
*myValue may be a public variable or form property.
=REQUERY("myListView")
thisform.pgfPageFrame.Page2.grdDisplayGrid.Refresh()

This is just general approach, you may display fruit names in combo, but select some fruit codes for use as filter value or view parameter.

HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform