Requery a Tabbed Form

[Robecca]

Hello

I’m working on a bowling database … I built a form (BowlerCheckIn) that has 3 tabs – “Check In”, “Assign Teams”, “High Pots”

“Assign Teams” tab has a multiple items form “AssigningTeam” on it and this form is based on the query “AssignTeam”.

After checking in the bowlers on the “Check In” tab, I want to be able to click on the “Assign Teams” tab and have it list the group of bowlers I just checked in. I thought if I put the following code on the OnClick event procedure “Me.Requery” would work but it does not.

Any ideas?

Thanks! Robecca

 

[JHB]

Place it on the AssigningTeam form's enter event. I assume that the name of the form is AssigningTeam, else you have to change it.

Private Sub [SIZE=3][FONT=Calibri]AssigningTeam[/FONT][/SIZE]_Enter()
  Me.[SIZE=3][FONT=Calibri]AssigningTeam[/FONT][/SIZE].Requery
End Sub

 

[Robecca]

Thank you JHB, that was exactly it. I'd been trying it on the tab control but chaning to the form worked perfectly!

 

[JHB]

You're welcome, glad to help you.