Refresh subform; filter by selection on mainform

[Bonnie A]

Hi everyone! Using A02 on XP. I have a table [UnclaimedTable] with lots of
records that need to be matched up, if possible, to records in another table
[DistribTable]. So I have a main form with [UnclaimedTable] records and a
sub form with [DistribTable] records.

We may only have a [DateMailed] or a [LName] to search by. The purpose of
this is a research task where we are trying to figure out where to look (pull
the files) for more information that may allow us to identify records from
the [UnclaimedTable]. The fewer files to pull for each, the better. I hope
to use a filter toolbar to fine tune the selection.

My thought is when I open the main form [UnclaimedTable] with no selections,
all records from [DistribTable] will show on the sub form. If I click into
[DateMailed] on the main form (which on the record showing might be
08/20/2003), I want to 'filter' or 'refresh' my sub form to show all records
in [DistribTable] with a [DateMailed] of 08/20/2003. If I happen to know the
contract number or some other bit of info, I'd then like to be able to
further filter the data showing on the sub form using the filter tools.

I know I can just open the table or a query of the table (read-only) and use
the filter toolbar but I would really like to be able to 'see' my
[UnclaimedTable] record that I am currently researching also. Am I doing
this wrong? Is there an easier way to do this? I think I'm on the right
track but not sure if I'm going in the right direction.

Thanks in advance for any help or advice. I really appreciate how much time
you give to help.

 

[Jeanette Cunningham]

Bonnie,
there is a sample search form with code that would the sort of search you
are asking for on
http://www.allenbrowne.com/ser-62.html

Jeanette Cunningham

 

[Bonnie A]

Hi Jeanette! Thanks VERY much for the info. I will follow the link you
provided and check it out.

Thank you for the time you take to help others!!!

--
Bonnie W. Anderson
Cincinnati, OH

Bonnie,
there is a sample search form with code that would the sort of search you
are asking for on
http://www.allenbrowne.com/ser-62.html

Jeanette Cunningham

Hi everyone! Using A02 on XP. I have a table [UnclaimedTable] with lots
of
records that need to be matched up, if possible, to records in another
table
[DistribTable]. So I have a main form with [UnclaimedTable] records and a
sub form with [DistribTable] records.

We may only have a [DateMailed] or a [LName] to search by. The purpose of
this is a research task where we are trying to figure out where to look
(pull
the files) for more information that may allow us to identify records from
the [UnclaimedTable]. The fewer files to pull for each, the better. I
hope
to use a filter toolbar to fine tune the selection.

My thought is when I open the main form [UnclaimedTable] with no
selections,
all records from [DistribTable] will show on the sub form. If I click
into
[DateMailed] on the main form (which on the record showing might be
08/20/2003), I want to 'filter' or 'refresh' my sub form to show all
records
in [DistribTable] with a [DateMailed] of 08/20/2003. If I happen to know
the
contract number or some other bit of info, I'd then like to be able to
further filter the data showing on the sub form using the filter tools.

I know I can just open the table or a query of the table (read-only) and
use
the filter toolbar but I would really like to be able to 'see' my
[UnclaimedTable] record that I am currently researching also. Am I doing
this wrong? Is there an easier way to do this? I think I'm on the right
track but not sure if I'm going in the right direction.

Thanks in advance for any help or advice. I really appreciate how much
time
you give to help.