Hi.
I got a form whose record source points to the entire data set of a table. I was wondering if this will cause an issue when record count is 100,000 or so, while the form's Data Entry property is set to Yes.
Should I create some criteria that loads only a subset of table data onto a form? If yes, how do you guys deal with this kind of situation? Date criterion? Transaction counts? I wanna know what has worked best in your own experience.
Thanks a lot.
Joe