How to pull records from a main form AND sub forms within Tabs

[cscotty via AccessMonster.com]

Hey All.

I have a main form named frm00Index. Within this form is a Tab control that
has 4 tabs. Each record on the main form links to the data on the sub form
perfectly.

I was wondering if there was a way to query the values from both the main
from and the tabs in the sub form. I would like to access the data in the
sub form. Somethign like this:

SELECT * FROM frm00Index

WHERE (sub form data = ???);


Is this possible?

Thanks,
Scott

 

[Jeff Boyce]

Scott

Access tables store data, Access forms display data.

You don't "pull data from forms" in Access. You query against the
underlying table data.

Create a new query in design view, add the appropriate table(s), select the
field(s) you want to see, add any selection criteria and/or sorting, then
run the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP