I have this code running in a Access 2000 database:
Forms![frmAdvCoSearch].[frmSearchSub].Form.RecordSource = bsql
But when I use the same code (but change the form names) in a different, brand new Access 2003 database to reset the SQL of two subforms on the same primary form, it doesn't work. So, I checked some PAQs and found that the syntax they used was slightly different:
Forms![frmSearch]![frmBuyers].Form.RecordSource = bsql
Forms![frmSearch]![frmSellers].Form.RecordSource = ssql
But that still doesn't work!! ANY IDEAS?!
THank you in advance,