By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Searching Child Forms

P: n/a
Is there a way to use the built in access find/replace to search values
in a child form accross multiple parent records.
IE.. If have a parent form has a record for every baseball team with
summary info and a child form that lists all the players. Can I
search for a players name and be taken to the parent record that has
this player in the child form.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The built-in Find will only locate items that are loaded into the form. If
your form is set up so the subform shows only the values that match the
record in the main form, the unrelated values are not in the form, so the
Find cannot find them.

For an alternative approach, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<td*******@yahoo.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Is there a way to use the built in access find/replace to search values
in a child form accross multiple parent records.
IE.. If have a parent form has a record for every baseball team with
summary info and a child form that lists all the players. Can I
search for a players name and be taken to the parent record that has
this player in the child form.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.