Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View SQL SELECT statement from form click

Status
Not open for further replies.
JeffAlton

JeffAlton

Programmer
Joined
Apr 19, 2003
Messages
42
Location
US
I want to view the results of an SQL SELECT statement that is in the code section of a form. How do I do this?
 
Sort by date Sort by votes
Why not using a ListBox with your SQL instruction as RowSource ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
You can also paste the code into a query. Just switch to SQL view and paste the code.
 
Upvote 0 Downvote
..or for slightly more versitality, a subform with your SQL as RecordSource?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Zyborg
  • Locked
  • Question Question
Using a variable as reference to a form
Replies
5
Views
1K
Zyborg
Zyborg
V
  • Locked
  • Helpful tip Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
860
strongm
strongm
BFroeschlKC
  • Locked
  • Question Question
Publisher Automation from Access Frustration
Replies
3
Views
4K
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open
Replies
14
Views
3K
dhookom
dhookom
Viswa.R
  • Locked
  • Question Question
Dimension import from Autocad to Excel
Replies
0
Views
685
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top