Hi Hasan,
I worked on your db and hence attaching it back with some changes in the Search Query of the subform. (I worked on some fields)
Please note that I am using Microsoft Access 2011 and with 64 Bit, so I have converted your db to this verion. Anyhow I am pasting here the SQL of search query:
Code:
SELECT Account.AcTypeID, Transcation.DepositAmount, Transcation.[W/DAmount], Transcation.Date, Transcation.PayDetails, Transcation.Category, Transcation.Description, Transcation.TranID, Account.AccountName, Account.AccountNumber, Account.AccountID
FROM Account INNER JOIN Transcation ON Account.AccountID = Transcation.AccountID
WHERE ((([AcTypeID]=[Forms]![SearchForm]![cboactype] Or [Forms]![SearchForm]![cboactype] Is Null)=True) AND (([AccountName]=[Forms]![SearchForm]![cboacname] Or [Forms]![SearchForm]![cboacname] Is Null)=True) AND (([AccountNumber]=[Forms]![SearchForm]![cboacno] Or [Forms]![SearchForm]![cboacno] Is Null)=True));
you can copy and paste the query to your search query. Also there are some changes I made in the Click Event of the Search Button and Clear Button of the Form:
Hope this Help! and you can go through for other Fields/Control on your Form: