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"





Reply With Quote