Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to click on Grid to pick record?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00031037
Message ID:
00031041
Views:
49
>Hi,
>My form has a textbox and a grid. It's a lookup screen for racehorses. >When the form displays, the textbox is blank and the grid is at the top >of the table showing the first few records.
>Let's say I'm looking for "Secretariat". I enter "Secre" into the >textbox. When the textbox loses focus, it's codepage does a SEEK for
Codepage? Egads man, I hope you meant the LostFocus or the Valid event.



>"Secre" and displays the first hit and a few of the next records:
>Secreta
>Secretarial Queen
>Secretariat
>etc.
>The record pointer in the table is currently sitting on "Secreta".
>Now, I want to click on "Secretariat", release the lookup screen, and refresh the parent form.
>I assumed that clicking on "Secretariat" would move the record pointer but it doesn't! The parent form refreshes with the record pointed to from the SEEK, "Secreta"
>How do I get the click event on Text1 of Column1 in the grid to also move the record pointer?
>
>Thanks!
>John Morga

I think the problem that you are having is that you are using the click event of the textbox in the grid. You should be using the dblclick event. Double clicking on Secretariat will then move the record pointer and do the form you need. The Click event doesn't work because the grid never fires the BeforeRowColChange and AfterRowColChange event and so the pointer is never moved.

Michael G. Emmons
memmons@nc.rr.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform