Avoiding #Deleted

[CedarTree]

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?

 

[isladogs]

Not quite clear why the data isn't there immediately.
Is the subform record source only added after you make the first selection?

Anyway perhaps hide subform2 until the data has been loaded?

 

[theDBguy]

Hi. You didn't specify how you're "loading" the data, but maybe you could try "unloading" it from subform 2 first before reloading it again. Just a thought...

 

[CedarTree]

I think hiding the subform works. Thanks.

 

[theDBguy]

I think hiding the subform works. Thanks.

Good luck and let us know how it goes. Cheers!

 

[AccessBlaster]

After the delete operation, can't you requery or refresh the underlying record source for that subform2 ? Just speculating.

 

[missinglinq]

...After the delete operation, can't you requery or refresh the underlying record source for that subform2 ?

Actually...the OP says nothing about Deleting a Record!

Does #Deleted really show if data is simply 'unavailable?'

Or is this a sign of corruption?

Linq ;0)>

 

[AccessBlaster]

Actually...the OP says nothing about Deleting a Record!

Does #Deleted really show if data is simply 'unavailable?'

Or is this a sign of corruption?

Linq ;0)>

Good point. But hiding corruption cannot be the answer either.

 

[missinglinq]

I agree, of course! Preventing an error, rather than covering it up, is always, well at least always, the way to go!

I just wondered if anyone knew of any other reason for #Deleted to show except when a Record had actually been deleted.

Linq ;0)>