Hello,

I am working with your sample application (CustomerMaintenance.vb), looking at the mechanics of the customer maintenance form.

My question is how does one harness the record navigation events in the maintenance toolbar?

Psuedocode for problem case (boCustomer1 = boCustomer)

1.) User browses (customer maintenance form), returns to main form which fills with top 1000 records

2.) User navigates, gets to end of recordset (boCustomer1), stops.

3.) Arbitrarily, last name of record stopped at is “Erickson”, customer_id = 1000

Unless the user browses again and (somehow) enters a PK of 1000 then the user is ‘stuck’ with no real way to get to record # 1001.

What I am looking to do is as follows

1.)User navigates through datatable (boCustomer1)

2.)If record_num = MAX(record_num) then

a.    BoCustomer1.Save (commit any unsaved changes)

b.    New boCustomer As boCustomer2

c.    boCustomer2.FillbyPrimarykey (500) (previous and next 500)

d.    BoCustomer1.ClearAndFillFromCompleteTable (BoCustomer2, BusinessCloneDataType.ClearAndFillFromCompleteTable)

e.    (Event – reset (enable) navigation buttons)

f.    BoCustomer2.dispose, BoCustomer2 = Nothing

Obviously the #’s could be 10, 100, 1000 and so on. I am trying to create a seamless experience without holding the entire 19K+ table in memory, essentially implementing something similar to a scrollable cursor that is not tightly bound.

I could use my own record navigation controls to implement this but I/we like the look and feel of the Strataframe maintenance toolstrip.

Any thoughts on harnessing the record navigation events in the maintenance toolbar? I’ve been working through the object browser trying to find the right collection to iterate through so I can then access the controls and their events but I am just not getting it.

Thoughts/Suggestions on Scrollable Recordsets?

Thanks for your time – J