Database search help

[scottvb]

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

[Edneeis]

Post us some code and we'll hook you up!

If you are using DAO (sounds like it with the .index thing) then you may want to switch to ADO because you're going to have to learn it sometime. (If it doesn't like the index thing I remember something about one of the DAO properties had to be Table not view or anything if that makes sense)

[alex_read]

Can you paste some of the code here for us to look at?