Filter in Header retrieves wrong record

[orange]

Alan,


I don't see an attachment???

[pbaldy]

There doesn't appear to be an attachment.

I'd say we'd stop sending snow your way, but it seems we have a bunch more coming.

[alansidman]

mmmm? Wonder what happened there? Uploading one more time.

[pbaldy]

Like I suggested:

SELECT tContacts.ID, tContacts.Last, tContacts.First, tContacts.SigOther, tContacts.Mail1, tContacts.Mail2, tContacts.City, tContacts.State, tContacts.Zip, tContacts.Phone1, tContacts.Phone2, tContacts.Phone3, tContacts.Phone4, tContacts.AwayMail, tContacts.AwayCity, tContacts.Astate, tContacts.Azip, tContacts.Email1, tContacts.Email2, tContacts.BadAddress, tContacts.BadEmail, tContacts.MailToStmbt, tContacts.JoinYr, tContacts.Archive, tContacts.SecondParty
FROM tContacts
WHERE (((tContacts.ID)=[forms]![fContacts].[myselector]))
ORDER BY tContacts.Last;

[alansidman]

Thanks Paul,
I was trying to put that in the source for the combo box and not for the entire form. Big Thanks.

Alan

[pbaldy]

Happy to help Alan!

[orange]

Glad you have it resolved. (more time for skiing....)