VBA OpenForm and RecordSource properties problem

Hi all,

I had a problem on MS Access, I tried to code with OpenForm with Where conditions to open a form, and then after some activities, I need to do a requery on the form to a specific record, so I say [Form_mainform].Recordsource = strSQL, and now, the problem comes, it throws me an unknown error. But if I tried to open the form without the where conditions, the requery works 100%.

Please anyone help me to resolve?

Regards

PlayKid

post your code so we can have a look

pete

And the error. What's an "unknown" error? It should at least give you a number.