Ok I have a bug that I can't work out. I am using a form with a combo box that you can select a search topic - like 'name' or 'date' and I have a cmd button that is clicked to bring up a text box that askes for the string(in that field. I can't get it to reference the string in the combo box properly and keep getting an error 424 object required, which suggests it doesnt recognise the 'name' object when I recordset.index. I think it might be becuase my program only uses one table in the access db it references and I am using the code from the demo program that accesses and db made of several tables.
Can anyone suggest a solution? What type of search data input to others use for db searches????

Thanks,
Scott