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 TouchToneTommy 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
Apr 19, 2003
42
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
Using a variable as reference to a form
Replies
5
Views
758
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
640
strongm
strongm
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
breezett93
  • Locked
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
1K
dhookom
dhookom
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
522
Viswa.R
Viswa.R

Part and Inventory Search

Sponsor

Back
Top