Hello,
I have a form which i use mainly for adding new records to a table (although form is based on a query and not directly based on the query). Now as i am inputting records i have already about 8000 records on this form. So my question is, since i basically use this form (almost only) to add new records, and when i open it it shows all the records, do you think that this is needed ... i mean does a form lacks performance or something since it loads all those records? and if yes, how do you suggest i can make it opens without loading the records.
TU
I have a form which i use mainly for adding new records to a table (although form is based on a query and not directly based on the query). Now as i am inputting records i have already about 8000 records on this form. So my question is, since i basically use this form (almost only) to add new records, and when i open it it shows all the records, do you think that this is needed ... i mean does a form lacks performance or something since it loads all those records? and if yes, how do you suggest i can make it opens without loading the records.
TU