Search textfield in form

[hoachen]

Most of the example i found online were combo search on a form which have
subform in it. Is it possible to search a textfield on multiple tables? For
example:
StudentTable (Student#, StudName, StudAddr, StudZip, ect)
OrderTable (Student#, Item#, ItemName, Order#, etc)
SpecialReturn1(Student#, Item#, ItemName, Special#1)
SpecialReturn2(Student#, Item#, ItemName, Special#2)

Will it be possible to do this? There were more 100,000 data. Most of the
time, when i make the join it always over 2GB size.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bd7b-50b0bfafca52&dg=microsoft.public.access

 

[jamie liddle]

Most of the example i found online were combo search on a form which have
subform in it. Is it possible to search a textfield on multiple tables?
For
example:
StudentTable (Student#, StudName, StudAddr, StudZip, ect)
OrderTable (Student#, Item#, ItemName, Order#, etc)
SpecialReturn1(Student#, Item#, ItemName, Special#1)
SpecialReturn2(Student#, Item#, ItemName, Special#2)

Will it be possible to do this? There were more 100,000 data. Most of the
time, when i make the join it always over 2GB size.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-bd7b-50b0bfafca52&dg=microsoft.public.access