combo box or ?

[Vince]

I have a multitable design. I want to create a form based
on those tables. I want to start with DJ Name from the
DJs table then the next field would be the Station Call
Letters which is column 2 from EMPLOYEE then I have
listener First name, Last Name, City, Phone, and ID from
WINNERS table. Then I have Prize Description from PRIZE
table.

I can't seem to make this work. I tried building the form
based on a Query.

Where I get stuck is: I want the user to select DJ Name
from Combo Box, then for Access to know that by selecting
a DJ, the corresponding Station Call Letters should fill
the Station Call Letters field automatically.

Then I would like to create a subreport based on the
Listener's full name showing all the dates a listener has
won on all stations under all Djs and what Prize they have
won. I got it to work but because I used DLookup to fill
in the station call letters the report would only populate
with the current record's station call letters.

So basically what I want to know is how to fill in the
station corresponding to the DJ in a form using multi-
tables.

Any insight will be appreciated.

 

[Ken Snell]

This URL has info on how to set up this behavior for a textbox and combo
box:

http://www.mvps.org/access/forms/frm0058.htm