Hello,
I have a form with bound textfields.
These used to show the last record that was entered in it by using:
Code:
Forms!frmProduct.Recordset.FindFirst "ProductID = " & DMax("ProductID", "tblProduct")
that code used to work and it used to show the last product in the databse.
What ive done right now is ive opened a form from Create -> More Forms -> Modal Dialgos
and ive pasted the same form and the same code into that.
Its now giving me an error which says:
Run Time Error '91'
Object vairable or with Block variable not set.
How can i sort this out and populate the bound fields with the last record in the databse?
Thanks..