Find button on main form that searches a subform.

[Coco]

I have a company main form and an account subform and I want to be able to
create a find button on the main form that will search a field on the
subform. The results will also need the main form data to reset relative to
the found data on the subform. Can someone tell me what is the easiest way to
do this in Access 2007? Thanks!

 

[strive4peace]

Hi coco,

so the answer is not so cryptic for you, please specify:

main form:
1. primary key of the table that the form is based on:
- fieldname (from the RecordSource -- not the controlname)
- data type
2. tablename the main form is based on

subform:
1. primary key of the table that the form is based on:
- fieldname (from the RecordSource -- not the controlname)
- data type
2. tablename the subform is based on
3. control Name that hold the subform

relationship:
the fieldnames in both the main tablename and the sub tablename required
to join the tables

other fields:
what are the names of the other fields you want displayed in the
combobox (besides the 2 key fields, which will probably be hidden) and
from which table do they come from? to make this easy, make a query to
show the two key fields and the other fields -- then post the SQL for
the query


Warm Regards,
Crystal
remote programming and training

Video Tutorials on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*