Deleting records from a subform

[Maracay]

Hi Guys,

I have a form with a continuous form as sub form, in this subform I created
a check box to mark the records I want to delete, in the main form I created
a command button to deleted those records at the end I do Me.Requery, but the
problem is that in the subform in the record I deleted I got the word Deleted
in the line where previously were the records I deleted, I just want to know
if there is a way to refresh the form to just disappear the record.

Thank

 

[Dirk Goldgar]

Hi Guys,

I have a form with a continuous form as sub form, in this subform I
created
a check box to mark the records I want to delete, in the main form I
created
a command button to deleted those records at the end I do Me.Requery, but
the
problem is that in the subform in the record I deleted I got the word
Deleted
in the line where previously were the records I deleted, I just want to
know
if there is a way to refresh the form to just disappear the record.

I just answered this exact same question yesterday for somebody else. The
answer is: don't requery the main form, requery the subform. You can do it
with a line of code like this:

Me.YourSubformName.Requery

 

[BruceM via AccessMonster.com]

Try requerying the subform control (the "box" containing the subform):

Me.SubformControlName.Requery

 

[Maracay]

Thanks

I just answered this exact same question yesterday for somebody else. The
answer is: don't requery the main form, requery the subform. You can do it
with a line of code like this:

Me.YourSubformName.Requery


--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)