Search results

I finally did it :-) It actually works. Combo box is filled with table that refers to each field in table. Displays description of 'Issue' and is bound to field name. Code runs from Command Button. This method saved me writing 33 seperate queries. A big thanks to Vince who pointed in the right...

Please help Can anybody help with this. I'm still messing about with the code but can't make it work. Thanks Mark

Are you there Vince? Hi Vince, I got this far but the code doesn't seem to run the query. The result that shows on the message box is the entire line after strSQL = I'm lost !!!! Thanks Mark Private Sub Command66_Click() On Error GoTo Err_Command66_Click Dim lngSel As String Dim strSQL As...

Thanks Vince, I'll try to use your suggestion. I'm not really into code but I know enough to get by. I'll see how I go. Mark

No, fields are not added to this table and it's been in use for about 5 years. Records are only added as rows.

Hi all, I'm impressed, I've only just found this forum. Unbelievable. Situation. Combobox uses data that references fields in a table with 31 fields and 19,333 records.(and growing) All data of interest in this table is 0/-1 (Yes/No). All fields in the table are simply called 1, 2, 3 etc. Using...