displaying search results using subform or other control

sugoi_kat

New member
Local time
Today, 17:12
Joined
Feb 22, 2006
Messages
6
Hi, I'm just wondering if it's possible to display the result of a query on a subform which does not have a relationship with any other table.

What I'm doing is creating a search form where a query is built from the users input (through combo boxes and text boxes) of what table, attribute and condition they want to search from. When they press the search button, I want the result to be displayed in a datasheet below the selection criteria

The first thing I thought of using to display information with was a subform, but I think the purpose of having the subform is so that it can be linked with a form. So, is there another control or way of displaying results. The results can come from any table.

Thanks.

sugoi_kat
 
use Listbox or Subform is good ? the answer: ALL IS GOOD !
when the users input condition ,let create an SQL string for that
then Subform.RecordSource = strSQL or Listbox.RowSource=strSQL
If you did not know how to find it creat an table have all of your info and select from that table !
But all what i said have been writen on this forum already ! Let find it and try ! :o :D
 

Users who are viewing this thread

Back
Top Bottom