[solved] is that possible to modify access query criteria from access module?
hi, like the above subject,
is that possible to modify the access query criteria from the access module?
thanks in advance
Re: is that possible to modify access query criteria from access module?
i found the way already, if you got something different, plez post to share :)
VB Code:
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"
Re: is that possible to modify access query criteria from access module?
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.