SQL and displaying result

  • Thread starter Thread starter 123xxxxx
  • Start date Start date
1

123xxxxx

i need to display the results of a SQL query on a form that already exists
how would i do this
 
123xxxxx said:
i need to display the results of a SQL query on a form that already exists
how would i do this
Click to expand...

The options rely quite a bit on what the results of the query are. Is it a
single field or multiple fields? Will it have a single row or multiple rows? A
single field, single row query could be displayed in a TextBox using Dlookup().
If there are going to be multiple fields and/or rows then you could use either a
ComboBox, ListBox, or Subform For the first two you would just use the query as
the RowSource for the control. For the last you would use it as the
RecordSource of the subform.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I display the results of a query in an existing form? 1
Printing SQL query results in a list of columns, instead of one long column 1
change to SQL - where and what? 1
Displaying query result on the same form as selection fields 6
Display query results 2
Form with Multiple Check boxes 3
SQL and Access... 2
Access Determine what query to run based on a checkbox 0

Back
Top