Finish the Rental Combo

3. When you go to the next step, preview the Combo Box and adjust the column width, if needed.

 

4. Store the value in the RentalID

The last part of the Combo Wizard is very important. This is another example of "matching socks."

 

The Movie form uses tblMovieTitles for the record source. That table has a RentalID field. You are going to match RentalID from tblRental to the RentalID in tblMovieTitles.

 

Your Combo will store, and look up, the RentalID.