Filtered subform based on a combo which is in the main form

[Rockape]

Hi all,

This is perhaps a deviation from my previous post and which i thought was getting me nowhere.

Anyhow my current problem right now is :

I have a main form and a subform. The subform is based on a query (whuch is based on a number of related tables. The purpose of the subform is to tag certain records of suppliers.

I am now trying to filter the records in the subform based on an entry that I enter in the main form via a combo. The idea being that I only all the records of the supplier that I require based on the condition of the query.

Is this possible. I am willing to submit my sample database.

Using A03.

Thanks

 

[John Big Booty]

Check out the sample and discussion in this thread.

 

[Rockape]

Thanks....I'll read it now and see whether I can adapt it..

 

[Rockape]

Hi,

John, the filtering works a treat but its what I want to do with the filtered records later that I'm having problems with. What I eventually want done is that I can tag the filtered records and assign it to a covering reference number.

1. I filter my database using this filtered method. (my subform is in continuous form view)
2. I tag these records in a one of the fields (Y/N type)
3. Then enter a covering reference for these records (which are unpaid invoices)
4. Once tagged this covering reference, which is now assigned several invoices, gets paid based on this covering reference.

I hope that makes sense!

Thanks