Is there a way to copy and paste while working in the Zoombox on a SELECT statement for a combo box. Thanks.
Is there a way to copy and paste while working in the Zoombox on a SELECT statement for a combo box. Thanks.
I've never used Zoombox. How did you activate it? I build SQL statement in query builder then copy/paste from SQL view.
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.
In design view of form, selecting combo box on form. looking at row source which is a select statement. right click in row source and select Zoom.
I think your way is easier. Thanks.
Yes, to build SQL statement directly in the RowSource, click the ellipsis (...) to open query designer.
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.
If you just need to do a quick copy and or paste, you can use the keyboard shortcuts; Ctrl+C and Ctrl+V.