Yah it's pretty quick and not a lot of flashing on the screen etc. I guess you would not have to update the Recordsource either if each form object was assigned its recordsource in advance and did not need to be dynamic.
Sometimes Helpful
Windows 7 64bit 
Access 2010 32bit
Yah it's pretty quick and not a lot of flashing on the screen etc. I guess you would not have to update the Recordsource either if each form object was assigned its recordsource in advance and did not need to be dynamic.
VIP
Windows 7 64bit Access 2010 32bit
Means building 20 objects (listboxes or forms or just queries). I would strongly resist this approach in favor of one form with a tab control. Just as easy for user to click a tab as select from a listbox.
Another consideration, I don't know if changing properties is possible in accde so if there is any chance of need to publish as executable ...
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Sr. Database Developer
Windows 8 Access 2013
Very nice. I will have to remember this if something similar ever comes up. Glad to learn new things.Originally Posted by June7
Sometimes Helpful
Windows 7 64bit Access 2010 32bit
That's how I was reading it, a lot of objects...... I use all of the above. Not necessarily in the same FE file but, the more tools, the merrier.
Query/Update what I selected
Subform data doesn't populate Report or Query
My combobox doesn´t update the selected value when I click on next record
Form doesn´t update with Query.
Posting Permissions
Reply With Quote