SELECT Residents.[Last Name], Reciepts.Date, Reciepts.[Street Number],
Reciepts.[Street Name], Reciepts.Amount
FROM Reciepts INNER JOIN Residents ON (Reciepts.[Street Number] =
Residents.[Street Number]) AND (Reciepts.[Street Name] = Residents.[Street
Name]);


I have a couple of combo boxes in my form that uses information from this
query to populate a table. The query allows me to type in the last name in a
box on my form, and then fill in the street number and street name using the
drop down box. My issue is that once I fill in the form once, and go to the
next line, the query still pulls the information from the first time. How do
you get it to recheck for each record without leaving the form and coming
back?