Find Record in Subform

R

Reb

I currently have a find record command button on the main form. When I
use the main form find button it only searches fields in the main
form.

I would like the ability to search ALL the records in a subform using
a find record command button. Currently when I put a find record
button on the subform it only searches the record currenly displayed.
Is there any way to seach (for example) ALL the Titles in that subform
table?
 
R

Richnep

I currently have a find record command button on the main form. When I
use the main form find button it only searches fields in the main
form.

I would like the ability to search ALL the records in a subform using
a find record command button. Currently when I put a find record
button on the subform it only searches the record currenly displayed.
Is there any way to seach (for example) ALL the Titles in that subform
table?
From what it sounds like you have a table and a sub table that is the
data source for the forms.

You need to make a reverse lookup form, in wich is the sub becomes
the "Main Form" and the "Main Form" of the form becomes the sub.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top