O
Oden1988
I have created a database using several tables which I incorporated into one
main form that uses subforms to populate all the tables. My question is how
do I create a query that will query the subform (by supplying input from the
user...I know how to do this part) and return the requested information into
the form. Basically, I input data into the main form, and when I want to
query (to find a specific set of data) I want that record to show in the
form. Without going into much detail as to the contents of the tables, I
have a main table with names and the other tables contain, email info, phone
info, and address info. Each table can contain multiple entries linked to
each name, so I need to be able to query on each table to pull that set of
linked records into the form for addition, deletion and/or changes to that
record; ie a new phone number for a person.
Thanks for any help you can provide.
main form that uses subforms to populate all the tables. My question is how
do I create a query that will query the subform (by supplying input from the
user...I know how to do this part) and return the requested information into
the form. Basically, I input data into the main form, and when I want to
query (to find a specific set of data) I want that record to show in the
form. Without going into much detail as to the contents of the tables, I
have a main table with names and the other tables contain, email info, phone
info, and address info. Each table can contain multiple entries linked to
each name, so I need to be able to query on each table to pull that set of
linked records into the form for addition, deletion and/or changes to that
record; ie a new phone number for a person.
Thanks for any help you can provide.