Refreshing Form

[oariav]

Hello All!

I got a form which after the action on it is finished, Its unload it, When i call it agein (by the show method) I see it in his last position. How do i do that every time its loaded its been shown in his inizilize mode?

Omri.

[Mark Sreeves]

if you laod the form before showing it you can move it to wherever you want

Private Sub Command1_Click()
 Load Form2
 Form2.Move 0, 0 'move it to wherever you want it
 Form2.Show
End Sub

[mark_dep]

You could set the settings for the form in the form_load,

Just as an example, say you have a label or a text box on the form, you could.

form_load
label1 = clear
text1 = clear
end sub

Mark

[oariav]

Ok Fox, That helped me a lot.

Thank You Very Much For The Help.

[flair]

hi

i have a similar problem.
i have a datagrid that is populated by a stored procedure. i m using sql server as the database.
every time i work on a form i want the changes in the data to be directly updated in the data grid at runtime

regards

[Deepak Sakpal]

hehe... you replied to an existing thread instead of creating new one. Anyways...

Suppose u have created a recordset Rs1 which is bounded to DataGrid1 then...

Rs1.Requery

will refresh datagrid records automatically.

[flair]

thanks
but i have already tried the requery method

i m using a data environment as the data source and the command type as a stored procedure.
when the command type is a table, requery works fine but it gives an error with stored procedures