[solved] is that possible to modify access query criteria from access module?

[asmdev]

hi, like the above subject,
is that possible to modify the access query criteria from the access module?

thanks in advance

[asmdev]

i found the way already, if you got something different, plez post to share

Dim dba As DAO.Database
    Dim dbq As DAO.QueryDef
    Set dba = CurrentDb
 
        Set dbq = dba.QueryDefs("Q_FOLLOW_COUPON")
        dbq.SQL = "SELECT * FROM BIODATA WHERE bCouponNo='" & txtSearch2 & "'"
        DoCmd.OpenForm "D_BIODATA"

[asmdev]

well, i just figure out i am so damn stupid...
if you use the button wizard, it could easily integrate a textbox to match a field inside your table filtering the recordset.