123xxxxx said:
i need to display the results of a SQL query on a form that already exists
how would i do this
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.
