I have a Form with a single Text Box, into which is filled a filtered recordset (ClientLST). The idea was to then allow the user to select specific Clients to add to another table. This all works but we now need to produce a report containing the ClientLST recordset. The system takes about 30 seconds to produce the list according to the dates and parameters supplied by the user, and I don't want to have the users waiting a further 30 secs. I have been able to pass the recodset but it fills the text box without it growing to fit the large amount of data.
Any ideas?
Any ideas?
