search problem

[JoeAcess]

Hi everyone

I am using access 2007, I have a form "FrmBorrow" where i enter all the details of book borrowed from the library. Now i have another form "Frm Defaulters" in which a query is placed which will show all the defaulters. But the Form is in a datasheet view. Is there any way i can click on one of the record and it will take me to the same particular record in Frmborrow


Or


Is it possible for me to put a button on frmBorrow and have two field entered by the user -date and book id, and then it will go to the particular record depending on the criteria entered. How is this possible?


Thanks

 

[aawsum]

Is there any way i can click on one of the record and it will take me to the same particular record in Frmborrow

What about using the onclick event
then use "docmd.openform formname,,,where statement"
where the where clause opens the form for the specific record you are clicking on. For example use the primary key value of the record as a reference.

or

if you want to open/goto the form and show all records and just go to the one that is similar
open the form with an argument (same statement as above, just use the last parameter to pass an argument (for example the primary key value of the selected record), the in the new form in the open event, use docmd.findrecord "argument"

Hope this helps