I am a newbie in Access Modules and & I am facing a problem
I have a database, which has 2 tables (Product , Order) ..
I have a query named qryProductOrder
I have a form, called frmProductOrder, which has all fields in qryProductOrder, it has some fields like (orderID, productID, date, etc)
I have a button , when I click on it, it should jump to the record set which shows OrderID = 3
On the click event of the button, I wrote the following code
dim qdf as QueryDef
set qdf = CurrenDb.QueryDefs("qryProductOrder")
qdf.sql = "select * from qryProductOrder where orderID = 3"
but when i run it I get an error message & then the program closes!