I have a form with 2 pages. The first page is an edit form and references table1. The second page is a search page that consists of a textbox and a grid.

The user enters a name in the textbox and in the lost focus there is an SQL SELECT from table1 executed and the results are placed in table2.

There is NO set relation between both tables.

I have 2 problems: When I first enter the form Page 1 displays Record 1 of table 1 and Page 2 diplays repeatedly the first record of the last search in table2. Then if I enter a name in the textbox and press ENTER the grid goes blank even if I included the command ThisForm.Refresh().

Is what I am trying to do possible? I am trying to avoid issuing a Browse commmand in an external window: it would look cleaner.

What is going wrong?

Thank you
Raymond