Query Help--Form

[Guest]

OK, I followed the instructions for making an AutoLookup query so that my
form would automatically fill in the addresses, phone numbers, etc., of the
customers...
I associated the form to the query by making the lookup query its Record
Source.

It works great!

However, when I open the query, or the form--they're blank. How do I make
it so that when you aren't entering a form, you can scroll through the
records by using the mouse wheel?

Before, when the table was the Record Source, it would do this. Each time I
rolled the mouse wheel up or down, it would go to the previous or next record.

 

[Guest]

I think I figured it out. First I tried to make the table it's record source
and only link the appropriate autolookup fields to the query--but I kept
getting errors...

Then I changed the Join Properties to Show All of the main record that I
want the form to scroll through, and it worked.