Filtering data into repeating table

[Nolene]

I have a form with two controls - DocType & Property - and a Access db as
Secondary Data Source (SDS) with the fields DocType, Property, Name &
Section. I want to create a read-only distribution list from the SDS. I have
put a repeating table in the form and populated it with the data from the
SDS. How do I filter the data so that only the data that matches DocType &
Property is displayed? Or should I use some other control rather than the
repeating table?

Example:

On the form DocType is selected and = Lease; Property is selected and = SCP.
The repeating table will display Name and Section only for records whose
DocType field = Lease and Property = SCP.

Bonus question:

Is there a way to grab the displayed names and enter them into the To: field
in an Outlook email message if a button is clicked? (Our Outlook will then
lookup the corresponding email addresses).

 

[em]

hi,
assuming that the two controls are just simple text fields: did you try
setting the data filter for the repeating table in design mode (on the
property page of the repeating table) ?
regards
em

 

[Nolene]

The filter button is disabled (actually it disappers altogether) when a
secondary data source is selected. If I leave the table with the main data
and just set the fields within the table to the Secondary Source, the filter
just doesn't work.

 

[ChrisM]

did you figure this out? The filter button is not available for me and I am
also using a secondary data source as the bound to the repeating table.

All help says update the properties of the repeating table but this is not
available. I want to limit what is shown in this table based upon a list box
selection.

any help is appreciated.

 

[Nolene]

No I haven't. I did get a response from someone in another forum though. It
appears that it can be done with custom coding and this person's company did
that sort of work -- I can't swing the cost though. Someone who knows VB
might be able to figure it out.