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 Mike Lewis 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
0
0
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

Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
92
Viswa.R
Viswa.R
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
137
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
154
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
288
dhookom
dhookom
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
182
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top