sorry, wrong query:

SELECT Residents.[Street Number]
FROM Reciepts INNER JOIN Residents ON (Reciepts.[Street Number] =
Residents.[Street Number]) AND (Reciepts.[Street Name] = Residents.[Street
Name])
WHERE (((Residents.[Last Name])=[Forms]![Reciepts]![Last Name]));

&

SELECT Residents.[Street Name]
FROM Reciepts INNER JOIN Residents ON (Reciepts.[Street Number] =
Residents.[Street Number]) AND (Reciepts.[Street Name] = Residents.[Street
Name])
WHERE (((Residents.[Last Name])=[Forms]![Reciepts]![Last Name]));

Row Source: one refers to one of these queries, the other to the second one.
I do have a requery maco identified in the "on Enter" property line.


"Larry Linson" wrote:

I do not see where the query refers to a field on the form, nor mention of
how "the drop down box" works off the query (that is, what its Row Source
is). We don't have enough information to be of much (or any) help.

Larry Linson
Microsoft Office Access MVP

"RA" wrote in message
...
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?



.