I hope you'll understand my request, my knowledge of english language is quite basic.
I've got a main form (with no SourceTable) and two SubForms (Meeting To-dos and not-Meeting To-dos).
The Subforms records are filtered using a function on the main form:
fntActualizar()
CLEAR(rstTarea);
rstTarea.SETCURRENTKEY(Date,”Starting time”);
rstTarea.SETFILTER(“Salesperson Code”,txtFiltroVendedores);
rstTarea.SETFILTER(Date,’=>%1&=<%2’,datFechaDesde,datFechaHasta);
rstTarea.SETFILTER(“System To-do Type”,’=%1|=%2’, rstTarea. “System To-do Type”::Organizer);
CurrForm.SubTareas.FORM.SETTABLEVIEW(rstTarea);
CurrForm.SubTareas.ACTIVATE:
CurrForm.SubTareas.UPDATECONTROLS:
CurrForm.UPDATE;
I've got two problems:
1) When I first open the mainform (OnOpenForm trigger) i run the function, but the filters do not apply formely. After that whenever i run the function it works fine and the subforms show the right records.
2) Even when the records update properly, I want the subforms to show the first record when ever they're filter is updated. (I've tryed this with WshShell: it works fine if i run it from a button on the subform but not if i call it from the main form)
0
Comments
Function UpdateForm
CurrForm.UPDATE;
Then call it from main form
CurrForm.SUbFormName.Form.UpdateForm
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Yet the second point is not still working as I’d like to: When I update Meetings and Tasks Subforms, I want to show the first record on each table. To do that I execute:
CurrForm.Subform.ACTIVATE;
CurrForm.Subform.fntTakeFirst;
fntTakeFirst()
CREATE(WshShell);
WshShell.SendKeys('^{HOME}');
CLEAR(WshShell);
The point is, if I run this for both subforms, it only works for the last one I activate (and only if I do not activate any other object after that).
I had the same problem with the subforms but still did not solve it. The CURRFORM....... code should be placed in the open form or in the activate form?