filtering data other than combo boxes

[Ramnik]

Hi all,
I am using master/child form for data entry for packings and the details for this packings (i.e. the products inside a packing is entered in subform and packing master is entered in main form ).

In the detail subform i use a productId field which has look up from 1000 products , so i want to filter that particular combo box based on different types from product master ( from which it choses the products).

How many ways are there to filter that combo box based on different types ( which i have in product master as type,design,material etc).
One way of which is combo boxes on main form.

For reference please visit this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=261823

. One of experts advised me to start a new thread to find the answer. If you need , please visit my previous thread for my root question.

Thanks.

 

[Ramnik]

Thanks , I will try to do it this way.
But did you see my last post in that thread and can you provide me the reason why it happened ?

 

[Ramnik]

Here is a test.
Check it,

 

[Ramnik]

Please post a sample database that exhibits the behaviour and I will have a look. (Access 2007)

I suspect that's the correct behaviour however I would like to investigate further before committing myself.

Does my test database describes the problem well?????

 

[Ramnik]

I didn't find your example particularly helpful because it did not appear to duplicate the issue you were having in the other database. I could see all the records, and there did not appear to be any missing "Blank" entries like in your other DB.

Its clearly duplicating the issue .
please see it again
I m sending u screenshots...

 

[Ramnik]

Yes i can see in the video that you got it working ok ... But how ??????
This is what I need . Please send me back the same test database which you have modified and posted the video . Thanksss

 

[Ramnik]

Here is the rowsource as you suggested...
see attached pics.

 

[Ramnik]

Okk what u suggested is i should give the rowsource in VBA instead of form properties . Am I right????
And should i give it in on load event of form and after update event of controls ????

Thanks .