I am still getting syntax error of from clause on the follow code?

If you are getting an error on the "from" clause, then one of your table names is incorrect. What are the values of txtchildMDBF and txtmasterMDBF? Are they valid table names? I will take a guess and say that the value for txtmasterMDBF is incorrect in your subquery. Either the value is wrong or the table doesn't exist.