forms 4.5 problem

I have a form that allows a user to enter a number, which is passed (along with various other things) to another form - using a parameter list and the call_form command.

[Quoted] In the called form, i have defined a 'default where' clause that will return anything from 1 - 8000 records (depending on the data). The number that the user enters is the record that will be displayed, but i want them to be able to scroll up and down through the (1 - 6000) records at will. (I have also a post-query trigger that sets up various non-base things for each record).

I issue a go_record(number) command in the when_new_form_instance trigger to ensure that it is the record displayed. My problem is that the larger the number entered by the user, the slower the performance of getting to the required record is. Is there any way around this?

Ie user enters 5343 and the default where returns 7500 records. This is quite slow to display record 5343. If user had entered 7, this would be very fast.

thanks in advance for any help Received on Tue Nov 16 1999 - 00:21:23 CET