Same ole problem different spin.
I have a split database forms /data (actually several datas and forms for security but mainly just dealing with the first). If you have been dealing with access awhile you know you can experience first form slow down when you open up a form that has some sort of link to the table itself (ie attached, listboxes). I have gotten around this problem for the most part by detaching the forms from the tables and using recordsets to populate the forms on the required records.
My issue come from list boxes.. I have a hard time doing a descent search using anything but list boxes, however this is attaching the form to the table either by using a query or by coding:
me!mylistbox.rowsource = "select Blah blah"
which doesnt run any faster. Now does anybody have a better way of doing this.. maybe an dao solution? I am ashamed to say I am not too familiar with ado because welp I have been able to do everything I have needed in the past with dao and I never spent the time to learn it. however if any one can give me some code/ideas I would greatly appreciate it.. sorry to make this so long please let me know if you have any solutions.
I have a split database forms /data (actually several datas and forms for security but mainly just dealing with the first). If you have been dealing with access awhile you know you can experience first form slow down when you open up a form that has some sort of link to the table itself (ie attached, listboxes). I have gotten around this problem for the most part by detaching the forms from the tables and using recordsets to populate the forms on the required records.
My issue come from list boxes.. I have a hard time doing a descent search using anything but list boxes, however this is attaching the form to the table either by using a query or by coding:
me!mylistbox.rowsource = "select Blah blah"
which doesnt run any faster. Now does anybody have a better way of doing this.. maybe an dao solution? I am ashamed to say I am not too familiar with ado because welp I have been able to do everything I have needed in the past with dao and I never spent the time to learn it. however if any one can give me some code/ideas I would greatly appreciate it.. sorry to make this so long please let me know if you have any solutions.
