March 23rd, 2005, 11:25 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 4
Time spent in forums: 27 m 57 sec
Reputation Power: 0
|
|
|
Starting a form at the Nth record
I have a query driven, filtered form that I sometimes need to start at a record number other than the first record. (Instead of record #1, I need to start at #37)
I have information available so I know and can set a starting record number in VBA.
1. Can this be done in VBA or do I have to remove the query from the RecordSource line and do all navigation with VBA?
2. If I key the value in the record selector block and press ENTER the form goes to the 37 th record. Is there a way to access the Record Selector in VBA or can this behavior be produced in VBA?
(If you could refer to the source where you found the answer to this, it would be much appreciated. I’d really like to become better at finding answers to stuff like this myself.)
Thanks
****Hob
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
