SidLancing: Yes, I am here for a short while. I have been watching the posting by PHV and yourself as you guys seem to have gotten the two combox to work. I am a little confused at this point without seeing the form because the combobox names and field names seem out of sync. This is confusing. But, let me try to explain the combobox thing.
First, the RowSource of a combobox is either a table, SQL, or a saved query in most cases. There also a value list or field list but we won't deal with them here.
The rows returned from the RowSource can have many columns. The column that you designate that will be the value of the combobox upon the user making a pick is referred to as the Bound Column. The column count tells the combo how many columns are in the RowSource recordset. And, the column widths tell the combo how to display the columns.
Now if you have three columns ID, Name, Address being returned from the RowSource and we want the user only to see and pick according to Name then we set the column widths to 0;3;0. This will show only the name in alpha order if that is designated in the RowSource query. Now to use the values we can refer to the combobox name itself. The value of the combobox in this example is dependent upon the Bound Column setting. If we choose to select column 2 as the Bound Column then the value after the pick will be the name that was selected. But, that is not a very good choice if we are wanting to use a definitive value to make a comparison in another combobox query due to duplication possibilities. Normally you pick a column that is unqique. So, if we pick column 1 then the ID value which is unique to each name will be the value of the combobox and if the combobox is a Bound Column to an underlying table/query then the record will be updated with this ID value.
Now in your second combobox the rowsource was making a comparison of a field in a table back to the value of this form control(combobox1). Comparing a fields [ID] = FORMS![currentformname]![combobox1] should select the correct records. Conversely if we don't set the Bound Column to 1 but rather set it to 2 in the first combobox then this comparison would compare the [ID] field to the Name field that was choosen. Thus now records to be found.
One last issue. References to a combobox can be made to all of the columns in the combobox no matter what Bound Column is selected. This is done by use of the .column(x) property. If you have 3 columns ID, Name, Address you may through code refer to them as FORMS![formname]![combobox1].column(0)...column(1).. ..and .column(2) respectively. The numeration of the column property starts at 0 through N-1 number of columns.
I hope this posting has helped you understand a little better some of things PHV and I were working with when we were asking questions concerning Bound Columns and RowSource recordsets.
Post back if you have any further questions.
[COLOR=006633]Bob Scriver[/color]
[COLOR=white 006633]MSU Spartan[/color]
