Thomas_VDB
asked on
MS Access : Goto record
Hi all,
I am relatively new to Access. My question is pretty basic, so hopefully the aswer will be easy for you guys.
I have a main form to manage my contacts, and a "Search Contacts" form. This searchform works great : I can fill in the search criteria, hit the 'search' button, and it shows all records that fulfill the criteria. Next to every record there is a "Goto" button, that launches the main form with the selected record. I used the
docmd.Openform formname,,,criteria
methode to open the contactsform with the resulting record.
But in this contactsform, there is only one record in the recordset.
Is there a way that when I click on the "Goto" button in the searchform, that the mainform is opened with all records in the recordset, but the bookmark is set correctly so the chosen record is visible.
I allready tried to copy the bookmark from my search-query to the recordset of my main form, but these are incompatible.
Thx
I am relatively new to Access. My question is pretty basic, so hopefully the aswer will be easy for you guys.
I have a main form to manage my contacts, and a "Search Contacts" form. This searchform works great : I can fill in the search criteria, hit the 'search' button, and it shows all records that fulfill the criteria. Next to every record there is a "Goto" button, that launches the main form with the selected record. I used the
docmd.Openform formname,,,criteria
methode to open the contactsform with the resulting record.
But in this contactsform, there is only one record in the recordset.
Is there a way that when I click on the "Goto" button in the searchform, that the mainform is opened with all records in the recordset, but the bookmark is set correctly so the chosen record is visible.
I allready tried to copy the bookmark from my search-query to the recordset of my main form, but these are incompatible.
Thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER