I need to have my query results displayed in a subform.

[ChaseCox]

I have a form that I use to input criteria that I have then being passed into a query. Currently the query saves the results as an excell file. I would also like to have the results show up in the form, I guess as a subform. If this is possible I would love some assitance on this. Thanks to all of you who have helped me so far.

[NeoPa]

You don't seem to be following what I'm saying here.
1. What are you referring to? Tables or databases?

In your latest post (#20) you refer to a ComboBox. This is the first mention of it that I can find.
How do you expect anyone to answer your questions when they keep changing and you don't respond to requests for clarification but just go on your own sweet way?
It is now unclear what you're wanting to do as well as what you want to do it to.
Please try to clear this up as I don't want to be dealing with this question in days to come.

[ChaseCox]

I want my form to be able to look at different databases. I would like to have the option to select the DB from a dropdown menu, or maybe by checking a box. I am not sure how else to word my request.

My form is providing the criteria for my query which is looking at the DB.

I am as confused as you are apparently. I really need some help on this. Sorry if I am confusing people.

[NeoPa]

OK let's take this slowly.
Do you understand the difference between a database and a table (You must answer questions when they are posted if you want people to work with you)?
If so then we need to know that. Your question seemed to switch between the two as if you assumed they were indifferentiabl e (the same).
You are, presumably, showing details on a form for a particular type of record (from one of similar tables). On this form you also have a ComboBox from which the operator should select the particular table to be used at the time. I suggest you need to have all the tables available in your front-end database (the one the form is run from). If any are from other (back-end) databases then their tables should be linked into this one so that all are available to this one.
How is your ComboBox populated with the table names (You need to answer this question too)?
When the operator has selected an entry from the ComboBox (This will trigger an AfterUpdate event in which you can place some code), you need to set the RecordSource of the form and ReQuery it.
If you would like some help putting the code together for this you will also need to provide the names of the Form and the ComboBox control on the form.

[ChaseCox]

Do you understand the difference between a database and a table (You must answer questions when they are posted if you want people to work with you)?
I am not aware of the difference.

Your question seemed to switch between the two as if you assumed they were indifferentiabl e (the same).

Thank you for delineating this. (defining)

I do not control the DB's. I am trying to search through them to get the info I need.
How is your ComboBox populated with the table names (You need to answer this question too)?

I do not know how to populate the combobox with the names. I am not sure of how to do this.

[NeoPa]

I gave a basic description of the difference in Post #19 but here is another.
A database is (generally) a file which contains various types of object within it. One of those object types (usually contains many of this particular type) is a table. A table contains data grouped together by Record (Row) and Field (Column).
For instance you may have a Customer Table which contains an ID field; a Name field and some Address fields. Every customer in this table can have an ID; a Name and some Address data. Another table, inside the same database could be a Supplier table which would contain its own fields and all the records in it could have data in all those fields.
Queries; Forms; Reports; etc are other types of objects that can be stored inside a database with (but not inside) the tables.

Assuming that you need to select TABLES rather than DATABASES in your ComboBox, we probably need to look at the possibility of storing your data in a single table, but with a field added to differentiate between your different types of data.
Before we go on, let me know if any of this makes sense to you.

[ChaseCox]

Ok I am following you. I am working in something called the Falcon Database. I understand now that I am looking at tables within that Database. So I need to be able to dynamicaly change which table the form looks at.

I do not think I can store all of the data in one table, since each table is updated independently of eachother by someone other than myself.

[NeoPa]

OK. That's a lot clearer now :)
Do you know which tables are to be included in the list?
If so, please post the full list of them.
If not, please indicate how to determine which tables to select from among all the tables you have available (in your database).

[ChaseCox]

OK. That's a lot clearer now :)
Do you know which tables are to be included in the list?
If so, please post the full list of them.
If not, please indicate how to determine which tables to select from among all the tables you have available (in your database).

Not at the moment, I would guess there would be about 9 or 10. I will know more after todays meeting. I will told which tables to include.

[ChaseCox]

it may be possible to load all of the tables into one. I will let you all know after lunch. Thanks.

[NeoPa]

Lunch?
It's nearly time to go home.
It sounds like we have a static list anyway. That's quite straightforward to deal with when you let me know the list (As exact and precisely as possible). Please use [] around the table names.