Refresh main form when record in subform deleted?

[mudstuffin]

Hello.

I am building an access xp db for my sports club which holds information about the matches, players, finances etc.

Within that I have a form with a subform on it which lists each match and I add in who played in that match. On the main form, I have a textbox which counts the records in the subform. However, I want the textbox to update when I add or delete a record to the subform. I have got it to work with the adding of records by using the afterupdate event, which triggers a dcount, but it wont work when deleting a record.

mainform = matchtable1
subform = PlayersPlayedTable Subform1

textbox holding the recordcount (on mainform) = PlayersPlayed

Can anyone tell me how I can do it....?

Thanks,


mudstuffin

 

[TheAceMan1]

How are ya mudstuffin . . . . .

Just move the [blue]DCount[/blue] function to the [blue]OnCurrent event[/blue] of the subform.

See Ya! . . . . . .

 

[mudstuffin]

Thanks for that TheAceMan1.

Tried that but still not working. Doh....!

Maybe I need to change the way the dcount is getting the data i.e. its taking from the table, maybe I should run a query, then requery afterupdate event or something like that, as it seems that the data is not updating immediately on delete (tried running after the delete event too) ???

Thanks again.


mudstuffin

 

[ssatech]

Have you tried to use the Requery or Refresh method in your main form.....

 

[mudstuffin]

Thanks for that.

I thought I did try that, but had another go after you suggested it, and hey presto, its sorted it.

I put:-

Me.Parent.Requery
Me.Parent.Refresh

in the delete event of the subform, and placed it before the dcount, otherwise the delete event seems to pull data before its truly updated.

Cheers for the nudge.


Mudstuffin.

 

[TheAceMan1]

mudstuffin . . . . .

Have you tried the forms [purple]AfterDelConfirm Event?[/purple]

[blue]   If acDeleteOK Then
      [green]'Your DCount Assignment[/green]
   End If[/blue]

See Ya! . . . . . .