Automatically list values from lookup list

[HVACMAN24]

I have 2 tables, one that stores contestant numbers (tblContestants, and Contestant Number is the PK) and one for an event the contestants participate in and get judged (tblCooling). tblCooling gets the contestant #'s from tblContestants but through a lookup combo box which I have to manually click on and select the #. Is there a way to automatically list all the #'s from the contestant table in the cooling table?

 

[CBrighton]

How about an append query to create new records in the cooling table using the data in the contestant table?

 

[HVACMAN24]

Is there a way to answer all the pop up questions before they actually get asked so it just runs through it without asking?

 

[CBrighton]

What popup questions?

If you mean things like "This will update x rows" then create a macro / piece of VBA which sets SetWarnings (or DoCmd.SetWarnings in VBA) to false before running the query, then back to true again afterwards.

 

[HVACMAN24]

Yep, thats exactly what I was talking about. Thanks I have it workings like i want now.