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.
 
Back
Top