Printable View
Hi
This might be too basic
i have two mdi childs: frm1 and frm2.
both get their data from the same table in ms sql. i first load frm1 and then frm2. when frm2 unloads i want the changes made in it to be shown in frm1.
load frm1 in the unload event of frm2 gives error. i have no clue how to do this.
i have also tried refresh but the changes don't get updated.
thanks in anticipation.....
Refresh your recordset in form GotFocus Event check it.
to load new data u have to call Recordset.Requery method of frm1 on frm2 unload.
this is what i can say without viewing code. If u can post ur code that will easy to find exact problem & solution.
i tried requery too.
it works fine when the command type is a table. but when i use a stored procedure requery too gives an error.
to show u the code i'll have to show the whole app.
btw, frm1 has a datagrid populated by the sp n i want the fields in the datagrid refreshed
error should be 'Operation not allowed when the object is open' or something like that.
it doesn't stop or give an error on the refresh query but there are no changes made. if u click on that record again u get a eof or bof error. the datagrid is not refreshed on load, refresh (or form or grid) requery
r u sure u r refreshing recordset which is bound to datagrid.
as i said my command type is a stored proc.
the command is given in a DataEnvironment
so i have tried :
DataEnvironment1.rscmdApproved.Requery
(.refresh is not an option with the recordset)
but i get the error
"no value given for one or more required parameters"
the sp has no in/out param. it is a simple select query
(but i cannot use the table as a command type)
any ideas.......