If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I want to create a form with a subform that uses data, one from a query that pulls data from table1 and one that uses table1.

Do you mean that the form data source is a query based on Table1) while the subform data source is Table1? If so, why don't you use a filter to derive a subset from Table1.

Originally Posted by grooner10

When ever I try this though, if I make the main form datasheet view, then the subform won't open unless I change the view to form view.

This is the normal behaviour of an Access form in DataSheet View. You need to create a Parent (main) form that will act as a container and include the 2 forms you have now (one in datasheet view and one in form view) into it. You'll have to eventually orchestrate the communications between both subforms, though.

Originally Posted by grooner10

If I have the main form as the form view, the datasheet view is open but they aren't link, so If I choose one from the list it doesn't open up all of the details?

Do you mean that the form data source is a query based on Table1) while the subform data source is Table1? If so, why don't you use a filter to derive a subset from Table1.

This is the normal behaviour of an Access form in DataSheet View. You need to create a Parent (main) form that will act as a container and include the 2 forms you have now (one in datasheet view and one in form view) into it. You'll have to eventually orchestrate the communications between both subforms, though.

Yeah I do mean that.

But I didn't know that before and just using a form as a main and linking the two would work perfect I think. Just how do I link them in access?
Going to try and figure it out, but if there is an easy way let me know!

thanks so much for the help!

(I think I realized that the button thing is to complex for me, works fine without it)