REPLACE Function

Hello Experts, 

I have a find form (frmFind) and I have many subforms on this find form. 

I enter a number or text in txtFind on frmFind and if there is a hit, the subforms will show the data. I have many subforms on this frmFind.

I have an issue when trying to find a number (that is text) in a text field on the subform due to the number having a comma. 

Example:

If I enter 1000 in txtFind on frmFind it will find all hits with 1000 in a number field (whether or not there is a comma) or 1000 that is in a text field.

It wont find 1000 (with a comma) in a text field unless I enter it as 1,000 (with a comma) 

I am not sure how I can ignore a comma in a number formatted with a comma in a text field tblPmtProposalALL.Notes. 

I want to be able to enter 1000 in txtFind and find all occurrences with or without a comma in tblPmtProposalALL.Notes.  

I am not sure but REPLACE (and replace a "," with "") could be the function I need to incorporate in the bolded text below?   

thank you very much.  Let me know if any questions. 

here is my sql in 1 of the subforms on frmFind:

(Its modified to reduce space)

SELECT tblPmtProposalALL.ID, tblPmtProposalALL.DDNo, tblPmtProposalALL.Amount, tblPmtProposalALL.Notes
FROM tblPmtProposalALL LEFT JOIN (tblBankAccounts LEFT JOIN tblCurrency ON tblBankAccounts.Currency = tblCurrency.ID) ON tblPmtProposalALL.ID2 = tblBankAccounts.CoIDfk
WHERE (((tblPmtProposalALL.Notes) Like "*" & Nz([Forms]![frmFind]![txtFind],"") & "*"));