|
View Full Version : Combo Box don_w69 03-16-2001, 02:38 AM I have a combo box on a form which is connected to a table, I want to save each value in the combo box into different colum on the table. How do I go about this problem its been a nightmare. please help! llkhoutx 03-16-2001, 11:02 AM Use an update query to copy the contents of one field to another. zunan 03-16-2001, 06:16 PM If you have a combo box that has 4 columns of info for each record line, you can refer to each item value as: Forms!MyFormName!cboBoxName,Column(0) Forms!MyFormName!cboBoxName,Column(1) Forms!MyFormName!cboBoxName,Column(2) Forms!MyFormName!cboBoxName,Column(3) and so forth. The array in a combo box is "0-Based" so the first column enumerator is "0". You can just have the fields "=etc." |