query results into split form?

[murphy63]

I have a search form tied to a query.. this works fine.. I just need the query results to appear in another form I created. Can that be done? If so what property(s) do I need to update and with what.

thank you

[jwhite]

Is there anything keeping you from copying the query to the other form? More details of your design are needed...

[aytee111]

Is the second form a subform? If so, you can link the two forms.

[murphy63]

no, can I make it a sub form?

[aytee111]

Add it to the main form as a subform (on the Design menu), then use the linking properties to link it to the main form.

[murphy63]

the "Subform in New window" option is grayed out on both the main from and the one I want the results to show in

[aytee111]

Not sure what you mean by that. Go into design view of the main form, from the Design/Controls menu on the ribbon select the subform icon and click on the main form where you want it to go.

[murphy63]

I have an unbound search form, this form is used to provide the query with the information to query on:

this is the query:
SELECT tblDataSources.*
FROM tblDataSources
WHERE (((tblDataSources.Function)=Forms!SearchForm!searc hFunction)) Or (((tblDataSources.Alias)=Forms!SearchForm!searchAl ias)) Or (((tblDataSources.[Copybook-SAS Dataset Name-Table Name])=Forms!SearchForm!searchCopybook)) Or (((tblDataSources.[Copybook-SAS Dataset Name-Table Name])=Forms!SearchForm!searchSASDS)) Or (((tblDataSources.[Copybook-SAS Dataset Name-Table Name])=Forms!SearchForm!searchTable));

This works fine and produces the correct results in a datasheet. But I want the results to show in a second form which I have created that is a split form.

So what I want is the query results to shows in the top part of the split form as datasheet. The bottom of the split form is a update form. So you would select one of the records in the upper part of the split form and the information would show in the bottom form and there it could be updated.

thanks in advance.

[aytee111]

It seems to me that you are selecting the record twice, once on each form. If you can, get them to select the record to be updated in only one place.

The main form is where they will select the correct record. Then, by using the Link properties, the correct record will show up on the subform where it can be updated. You will link the forms using the field or fields that will identify the record(s) to be updated.

[murphy63]

the first form is the search form that provides the value for the query to search on.

I was able to tie a form to the query and that works fine.

The problem is when I open the query form just a box pops up to input the for the search variables. The query searches 3 fields so the box comes up once for each field. I just wanted the search form to execute the query with the query results in the split form.

[aytee111]

Can you attach your database, or just the forms in question?