TableBox Scrolling

polonious

Hi,

Here's a good one! I have a tablebox with two fields, on a small form that shows a list of item numbers. The second field is a Qty. field that is populated by a textbox elsewhere on the form. What I would like to do is, as each item is populated with a quantity, I want the list to scroll down to show the next item without a quanitity. The tablebox shows 6 lines, but it could have any number of records. Of course the user can simply use the scrollbar, but the form is on a handheld device and it would be easier if it automatically scrolled each time. Anybody got any ideas??

Cheers,

P

Belias

did you try:

rec.setrange(quantity,0);
rec.findfirst;
rec.setrange(quantity);
currform.update; //don't know if it is needed

you can do this in the onvalidate, of the quantity...
just try it, cause I don't know if it generates problems :-k

polonious

Cool thanks Belias, I'll try it now and come back to you in a few mins.

polonious

That worked a treat thanks Belias. Solved

Belias

Really?!?! :shock: ... test it carefully...i did some tests here and it appears to have some probems...
try to modify a record, putting 0 in it for example...

polonious

Yeh it's doing what I want it to do anyway. I left out the Currform.Update because it was trying to modify the record. If I was to leave it in, I would have had to add (False) to the end of it. But it wasn't needed.

kapamarou

You can do the following:

Create a record variable (rec2) for the same record as the form Rec.

Then:

rec2.RESET;
rec2.COPYFILTERS(Rec);
rec2.SETRANGE(Extra Filter Here); //<- Add Additional filters you need...
IF rec2.FINDFIRST THEN 
  Rec := rec2; //<- Don't make any modifications to rec2...