Show bookmark as 5th record in continuous form

S

Steven

I have a form when it opens if sets a bookmark on the DataSource query. It
shows as the first record in the detail of the continous form. How do I make
it show as the 5th record.

Thank you for your help.

Steven
 
F

fredg

I have a form when it opens if sets a bookmark on the DataSource query. It
shows as the first record in the detail of the continous form. How do I make
it show as the 5th record.

Thank you for your help.

Steven
Click to expand...

It's not wholly clear what you mean by "make it show as the 5th
record."

Do you wish to set the form's focus to the 5th record?

In the Form's Load event:

DoCmd.GoToRecord acDataForm, "FormName", acGoTo, 5
 
S

Steven

No, for Example lets say the query for the form returns 20 records. Based
on a criteria the criteria equals the 15th item in the query and sets a
Bookmark. My Continuous Form shows 10 records. Therefore with no extra code
the form opens showing records 15, 16, 17, 18, 19, 20. What I want the form
to open as records 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 with the 15th
showing as the current record.

Thank you for your help.
 
Top