Help with Forms & Combo Boxes

[pwel]

I need some help with access forms. For the purpose of this problem I will use two tables only. <br><br>Okay, I have two tables one for CD’s and one for the Year the CD was released. The year table has a list of years from 1950 – 2000 each with a yearID generated by an AutoNumber. The tables are linked by the yearID, simple enough.<br><br>Here’s my problem, on a data entry form I want to select the Year from a combo box (drop – down box, filled with the contents of the year table) and have it’s yearID value inserted into the CD tables yearID field, can I do this?<br><br>Any help would be much appreciated.<br><br>Cheers,<br><br>Paul Welding,<br><A HREF="mailtoaul.welding@ans-ltd.com">Paul.welding@ans-ltd.com</A><br>

 

[RoyVidar]

In your Main form (the CD form), using Design view, see to it that your toolbox is there and that the Wizard-button is &quot;pressed&quot;. Choose ComboBox and plase it in your form. Follow the instructions given in the Wizard;<br><br>Yes, I wan't it to lookup in a table or query<br>Select your Year-table<br>Select the Fields - Note - have both your ID and the Year-field<br>Hide/show PrimaryKey-field<br>Choose save the value in this field, (select YearID (Foreign Key))<br><br>Hope this is of assistanse;-)