Return all matching records

[junimation]

I have a database called LettersDatabase this databse holds all the letters that have been made including the path to the doc. I use SSN to ID the letters to customers on the Contacts Database.

Contacts database also uses the SSN to id the contacts



I have a form that creates new letters for customers in this form I have listbox that queries the LettersDatabase for all matching records based on the forms contact SSN to see how many letters have been made for that customer.


The problem is that my listbox only shows the first record matching that SSN but there are more records in that LettersDatabase with the same SSN that I need to have diplayed on the listbox as well.

I may be writing the query incorrectly.
Here what I have for the query on the listbox

Like[Forms]![LetterMaker]![txtSSN]

I try adding (&"*") to the end of the query but that does not help.


If anyone out there has the solution to this problem it would be greatly appreciated

Thank you

 

[Pat Hartman]

You should not use Like when you are not using partial search values.

 

[junimation]

ok then what is your suggestion
I try doing it directly on the form_load even with a "Where" statement but it does not work.

 

[Pat Hartman]

Use the equal sign:

Where [SSN] = [Forms]![LetterMaker]![txtSSN];