Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To: Use LISTBOX to select records to view/edit elsewhere
Message
From
15/08/2000 13:56:38
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
How To: Use LISTBOX to select records to view/edit elsewhere
Miscellaneous
Thread ID:
00405098
Message ID:
00405098
Views:
71
The project I am working on needs a form with a pageframe. The first page needs to have a list
of the "names" from a file and a display area that shows "detail" from the current record. When
the user needs to edit or add info, they go to page 2 and make changes there.

I thought I'd use a listbox on the first page. I got this to work by using a recordsource of 6-fields,
but the list needed to be sorted alphabetically. I ended up switching it to SQL and using...

select name, apmasid from apmas into cursor curLstRec order by name

in the record source. When I did this, of course I lost the feature of keeping the highlighted
record current. I have tried to use a InterActive change to seek or indexseek the apmas file
based on the unique apmasid. This is giving me erratic information and jumps at best. I also
tried setting the Bound to True and binding it to the apmasid and column 2. That is also erratic

Seeing the simplicity of the listbox is what I am looking for, isn't this the way to do it? What
am I missing (probably obvious 'cept to me). I thought about using a grid (I hate grids) but then
I have to program it so that the user can'tchange info in the grid, the current record highlights
entirely, etc. and I haven't even gotten into "orders" yet.


Thanks for any suggestions.
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Next
Reply
Map
View

Click here to load this message in the networking platform