How to avoid a browse window between clicking in a listbox and updating a grid 1

[german12]

I have a form with a list box populated with many last names (surnames) and a grid.
If I click on a last name in the list box, then
I want to see all people in the grid who have the same last name (with different first names).

*Click on a surname.
STORE Nachname TO mnachname


SELECT verwandte

thisform.TEXTGEBORENE.value = GEBORENE
thisform.TEXTGEBURT.value = GEBOREN
thisform.TEXTSTERBEDATUM.value = GESTORBEN
thisform.TEXTIMALTERVON.value = IMALTERVON
thisform.TEXTWAEREHEUTE.value = WAEREHEUTE
thisform.TEXTHINWEIS.value = HINWEIS

Thisform.label1.caption = "geborene"
Thisform.label2.caption = "Geburtsdatum"
Thisform.label3.caption = "Sterbedatum"
Thisform.label4.caption = "im Alter von:"
Thisform.label5.caption = "Alter"
Thisform.label6.caption = "Hinweis"

*Show a grid where all surnames and person are shown who own the same surname 


thisform.grid1.RecordSource = "select * from verwandte where nachname = mnachname"
thisform.grid1.RecordSourcetype = 4

*works - however I always see a Browse-Window before the grid is populated.
*Why?

How can I avoid that - before the form with the grid is shown, always a browse-window is visible?

Thanks
Klaus



Peace worldwide - it starts here...

 

[mm0000]

change the statement

thisform.grid1.RecordSource = "select * from verwandte where nachname = mnachname"

to

thisform.grid1.RecordSource = "select * from verwandte where nachname = mnachname into cursor cursorname"

 

[german12]

Thank you very much, mm000 !!
It can all be so simple, but only if you know how simple it is.

Greetings from Germany
Klaus


Peace worldwide - it starts here...