ms access use of bookmark

Hi this must be most idiotic question. But Please help me

I used bookmark porperty with some help. But when i had the code

me.bookmark = rs.bookmark  ( in a forms event ).

The question is what is the use of that line actually. I read about the bookmark property it says , each record in a forms recordset will be having a unique bookmark ( lets say unique number assigned to it ). But i still did not understand the purpose of me.bookmark = rs.bookmark and

when i found the record i am looking for. I cannot scroll to the other recrods on the form . THe scrolling gets locked .Can you help me in unlocking it. please help me . I will explain it again, if its not straightforward. Thank You.
vihaanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
A typical use of the Bookmark is as follows.
Lets say you have a unbound Combobox in the Header of a Form (continuous or form view) ... to select say a Company Name.  So, in the AfterUpdate event of the combo, you do a FindFirst on the RecordsetClone of the Form to locate that record.  Then ...you do what you showed above:

me.bookmark = rs.bookmark  ' rs is the recordset variable for the RecordsetClone

This causes (forces) the Form to 'go to' that record.  So, it's a way to find a record and then go to it.

Does that make sense ?

mx
vihaanAuthor Commented:
ya kind of so it just shows the the record we are looking for on the form.


And  one more thing is that if the formis showing total 20 records. And i used the bookmark property to got 15th record on the opening of form. Once the form opens and shows the 15 the record , , it does not lets me to scroll through the other records. SO if i want to scroll through the records. what should i do. Thanks for responding.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, I don't know. I would have to see that.
Right now ... I need to zzzzzzz.

mx
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

vihaanAuthor Commented:
ok thanks though then
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Setting or retrieving the Bookmakr won't "lock" your recordset from moving, so I'd suspect something else is occurring. We'd need to see the entire code block where you're using this to be able to provide additional assistance.

If you're setting a Filter when the form opens, then you'd not be able to move to other records unless you removed that Filter.
Dale FyeOwner, Dev-Soln LLCCommented:
Agree with Scott (LSM) that something else is involved.  Besides a filter, do you have the forms Navigation Buttons enabled?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Confirming: Something else is going on :-)
Dale FyeOwner, Dev-Soln LLCCommented:
Joe,

Thanks for the confirmation.  Those zzzzzz's sure did help.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Hey ... a LOT of folks have been 'confirming' my posts as of late.  I won't say anymore about that.

mx
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
vihaan:
Can you upload an MDB that does this?

mx
Helen FeddemaCommented:
You don't actually need to use the Bookmark for some operations -- for example, to synchronize a form with a selection in a combobox, this works fine:

Private Sub cboSelect_AfterUpdate()
'Written by Helen Feddema 29-Jun-2009
'Last modified 11-Feb-2010

On Error GoTo ErrorHandler

   Dim strSearch As String

   'For text IDs
   strSearch = "[______ID] = " & Chr$(39) & Me.ActiveControl.Value _
      & Chr$(39)

   'For numeric IDs
   strSearch = "[______ID] = " & Me.ActiveControl.Value

   'Find the record that matches the control
   Me.Recordset.FindFirst strSearch

ErrorHandlerExit:
   Exit Sub

ErrorHandler:
   MsgBox "Error No: " & Err.Number _
      & " in " & Me.ActiveControl.Name & " procedure; " _
      & "Description: " & Err.Description
   Resume ErrorHandlerExit

End Sub

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vihaanAuthor Commented:
good
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.