Hello,
Have a main form with two subforms.
First datasheet subform lets me select the record I want to look at. On Current, I then dymically load the data from sqlserver into the 2nd subform. For example, subform1 lets me choose which baseball team I want, and subform2 shows me statistics on that team.
When loading the underlying data for subform2, I temporarily see "#deleted". I get it... the data isn't there for a moment. But can I temporarily hide the #deleted? I've tried turning application.echo off, etc. Any other tricks? Maybe hide the subform while data loads?
Have a main form with two subforms.
First datasheet subform lets me select the record I want to look at. On Current, I then dymically load the data from sqlserver into the 2nd subform. For example, subform1 lets me choose which baseball team I want, and subform2 shows me statistics on that team.
When loading the underlying data for subform2, I temporarily see "#deleted". I get it... the data isn't there for a moment. But can I temporarily hide the #deleted? I've tried turning application.echo off, etc. Any other tricks? Maybe hide the subform while data loads?