Indentify a page index (tab)

[vgersghost]

Hello:

I have a form that has tabs on it. I have a list box on one of the tabs linked to a query, trying to show only those records that go with the person's name on the header of the form.

Example in query:

=[forms]![frmContacts]![Page]![4].[id] -- [id] is the person number.
This is were I get confused on how to identify the correct tab and make the data only show up for that person.

thx

 

[pbaldy]

There is no need to include the tab page as part of the reference.

 

[vgersghost]

Tried that

I tried just using:
=[forms]![frmContacts].[ID]
but the same record shows for all the other id's instead of their record.

thx

 

[boblarson]

You do not use the equals sign in the query (IF you are talking about the QBE Grid). Just use [forms]![frmContacts]![ID] in the criteria spot.

 

[vgersghost]

Clear up confusion. I think it's me asking question.

The equal sign is not there. Please look at attached database.

The form is contacts, the tab attendence. This record in the list box stays the same no matter which record you go to. Thats what I'm trying to fix in the query. The query is called "AttendanceForContact"


thx

 

[boblarson]

You were just missing a requery in the form's On Current event

Me.List138.Requery

 

[vgersghost]

WOW -- Thanks!

Such a simple solution to something that was driving me crazy!

Thank you!