Subject Re: Data refresh in a grid From Mervyn Bick <invalid@invalid.invalid> Date Mon, 31 Jan 2022 19:48:14 +0200 Newsgroups dbase.getting-started On 2022/01/31 19:19, Milind Nighojkar wrote: > Scenerio : > 1.In form1 DOJ is a date field in grid  . (Say current row position is 10) > 2. DOJ's  values is being inputed by opening  another form2 . > 3.Input is thru Datetimepicker  in form2. Form2 is closed > 4.After closing form2 value for DOJ in row 10 of  form1 is not refreshed. > (In form1 when row navigation is changed and re-entered in row 10 then the value is seen to be updated.) > > Any suggestions as to how the form1 grid row is updated or refreshed the moment cursor come back to form 1 > > Milind Nighojkar I assume your form2 has it's own query object to access the table.  If so, form2 is writing the data to the table but form1 will not see that data until its query is requeried. Unfortunately I can't put a little example together for you right now but this is what you need to do. If you are launching form2 using readmodal() you can simply add a line below the readmodal() command.     form.queryname.requery() When you open a second form with readmodal() all processing in form1 stops until form2 is closed so the requery() doesn't happen until the new date has been selected and saved. If you are using open() to launch form2 this approach won't work. In form1's onOpen event handler       set procedure to form2.wfm       form.form2 = new form2form()       form.form2.parent = form In form2 in the datetimepicker's onChange event handler      this.parent.parent.queryname.requery() Mervyn.