Focusing Record Pointer in First Position on LIST form ??

pskannaa

Can you suggest me, how to set the focus on list Form in First Record position...

because while clicking button,i am calculating data and insert the record in table using looping. so the pointer is set in the last record position.

I WANT TO PLACE IN FIRST RECORD POSITION, WHICH TRIGGER,COMMENT SHOULD I USE !!!

DenSter

Look at the SourceTablePlacement form property, which you can set to Last.

pskannaa

No, what i mean that i want to set the record pointer in the FIRST position...
Eg: in List i hav 75 records(rows)....when i opened the form the pointer is focusing on last ROW, but i want to be focus the pointer in FIRST ROW.

Belias

:-k :-k :-k :-k :-k
maybe you can set the same property to first instead of last....but i'm not totally sure :whistle:

devu_13

Hi Experts
By set SavedTablePlacement property i lost my data in list form.can u explain in better way?

Belias

(i'm not expert but i reply anyway )
it's not possible to lose data in this way...try to clear filters and/or refresh the form...
then check if you set the right property (maybe you set savevalues to "no"?).
anyway, no property can delete data in your underlying table

DenSter

All that this property does is put the cursor in a predefined position, it does not cause data to be lost. I believe it is you who needs to explain your requirement a little further.

canadian_bacon

when opening the form - in the OnOpenForm trigger add code:
FINDFIRST;

when pushing the button - in the OnPush trigger for the button add code:
FINDFIRST;

Belias

canadian_bacon wrote:

when opening the form - in the OnOpenForm trigger add code:
FINDFIRST;

when pushing the button - in the OnPush trigger for the button add code:
FINDFIRST;

there are 3 reasons for not doing this:
1. write code when there is a specific property for this
2. use FINDFIRST when maybe in this case is better to use find('-')....this is not always true...
3. you have to write the code in each form accessing this form: this is the worst thing :!:

pskannaa

FindFirst/ setting property for "First"....No LUCK !!!

any other idea....

Belias

have you got some code under onopenform trigger?

DenSter

pskannaa wrote:

FindFirst/ setting property for "First"....No LUCK !!!

I am going out on a limb here and say that you are not telling us everything. That property is basically hard coding the form to put the cursor on the first/last/saved position. You must have some code on the form that overrides this property.