Query Help--Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christian ><> - 02 Jun 2006 21:38 GMT

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.

Reply to this Message

Christian ><> - 02 Jun 2006 22:40 GMT

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.

> 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
[quoted text clipped - 10 lines]
> 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.

Reply to this Message