>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.