searching in a continuous form: wanted a placeholder

[Michiel Rapati-Kekkonen]

I have a continuous form, with 22 rows on display.
I make a change in some row and have the form requeried.
(I have to, because the query on which the form is based is not updateable,
and the change is made by code)
Then I go back to the record I was working on, by code,
but after that search, the record appears on top of the list of rows.
This makes me a bit dizzy, and most certainly the one who's going to use it.
What I would like is to find my row back on the same spot as before the
requery.
It would actually mean that in stead of searching for my record, I would be
searching for the record that was on top.
Is there a way to identify that record?

Or does someone know of a more clever way?

TIA

michiel

[Arno R]

Re: searching in a continuous form: wanted a placeholder


"Michiel Rapati-Kekkonen" <michiel@nonsen se.zzschreef in bericht news:1owzj.71$H Y5.13@read4.ine t.fi...
..

It would actually mean that in stead of searching for my record, I would be
searching for the record that was on top.
Is there a way to identify that record?

Check the SelTop property of the form

Arno R

[Stephen Lebans]

Re: searching in a continuous form: wanted a placeholder

See:

http://www.lebans.com/setgetsb.htm

SetGetSB.zip is a database containing functions to allow a user to Set or
Get the current position of a ScrollBar Thumb for a Form.

NEW - Apr. 02/2000 The current ScrollBar position is equal to the current
Record Number being displayed at the Top of the Form.

Works in Form or Datasheet view.

Ver 1.7

Fix bug in SelTop method. Now works with first page of rows properly and
sets the Top row correctly when moving forward in the recordset one row at a
time.

Ver 1.6

Use SelTop to save Restore current row's position after a Requery.

Ver 1.5

Added support for Horizontal ScrollBars.
--

HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.



"Michiel Rapati-Kekkonen" <michiel@nonsen se.zzwrote in message
news:1owzj.71$H Y5.13@read4.ine t.fi...

>I have a continuous form, with 22 rows on display.
I make a change in some row and have the form requeried.
(I have to, because the query on which the form is based is not
updateable, and the change is made by code)
Then I go back to the record I was working on, by code,
but after that search, the record appears on top of the list of rows.
This makes me a bit dizzy, and most certainly the one who's going to use
it.
What I would like is to find my row back on the same spot as before the
requery.
It would actually mean that in stead of searching for my record, I would
be searching for the record that was on top.
Is there a way to identify that record?
>
Or does someone know of a more clever way?
>
TIA
>
michiel
>

[Michiel Rapati-Kekkonen]

Re: searching in a continuous form: wanted a placeholder

Thanks you both for the hints and the samplebase
Since I use 2007 I converted it.
Do you think this affected the workings of the forms?
I have the impression, that when I stand on a certain row, the box above
should show me the vertical position?
But it sais 0
And the next box suggests that it will go to that row, but it stays still.
Is it indeed a matter of conversion?
or do I not understand everything right?

I will study it further
Thamks

Michiel



"Stephen Lebans" <ForEmailGotoMy .WebSite.-WWWdotlebansdot ...@linvalid.co m>
wrote in message news:47ced295$0 $4060$9a566e8b@ news.aliant.net ...

See:

http://www.lebans.com/setgetsb.htm

SetGetSB.zip is a database containing functions to allow a user to Set or
Get the current position of a ScrollBar Thumb for a Form.
>
NEW - Apr. 02/2000 The current ScrollBar position is equal to the current
Record Number being displayed at the Top of the Form.
>
Works in Form or Datasheet view.
>
Ver 1.7
>
Fix bug in SelTop method. Now works with first page of rows properly and
sets the Top row correctly when moving forward in the recordset one row at
a time.
>
Ver 1.6
>
Use SelTop to save Restore current row's position after a Requery.
>
Ver 1.5
>
Added support for Horizontal ScrollBars.
--
>
HTH
Stephen Lebans

http://www.lebans.com

Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
>
>
>
"Michiel Rapati-Kekkonen" <michiel@nonsen se.zzwrote in message
news:1owzj.71$H Y5.13@read4.ine t.fi...

>>I have a continuous form, with 22 rows on display.
>I make a change in some row and have the form requeried.
>(I have to, because the query on which the form is based is not
>updateable, and the change is made by code)
>Then I go back to the record I was working on, by code,
>but after that search, the record appears on top of the list of rows.
>This makes me a bit dizzy, and most certainly the one who's going to use
>it.
>What I would like is to find my row back on the same spot as before the
>requery.
>It would actually mean that in stead of searching for my record, I would
>be searching for the record that was on top.
>Is there a way to identify that record?
>>
>Or does someone know of a more clever way?
>>
>TIA
>>
>michiel
>>

>
>