Ed,

Be sure that you have indexes on any fields or expressions that could possibly have a bearing. You might try some basic tests from VFP command window to confirm that essentially equivalent operations (e.g. queries and browses) have the kind of performance you'd expect. Once you establish that the kinds of queries involved in your form are capable of performing adequately outside of the form, then you can return to working on the form. Isolating and resolving the problem in this way may be easier than going straight to the form.

Mike

>A form includes in dataenvironment two tables: members and payments.
>Form runs pretty fast with small tables: members -2K records(2M) & payment-2K records(200K).
>Form runs very slow when tables are large: members -35K records(30M) & payment-117K records(11M).
>What can I change to increase form speed?
>
>Ed