Filter problem in Material Tracking database

[bronson_mech]

Hi guys,

Greetings....i have created a database for tracking material i want to add filter option in Material Details form, i created a macro for that but when i click the combo box arrow(Filter Box) its asking to enter parameter error.... pls help me in solving this issue..... herewith i have attached the file...

material tracking.zip

[June7]

The FilterString field has "[open Material Details]." in its value. Access can't find anything by that name. Neither can I. Remove it and the form filters properly.

I have never seen this method of applying filter criteria. But then I don't use macros so maybe this is common with macros and I wouldn't know.

[bronson_mech]

oh thx....... do u've any other method for filtering.... can you pls share your idea.... i'm breaking my head in this filter, for a long time.........

[June7]

There are many ways to accomplish filtering. Here are two:

1. http://www.datapigtechnologies.com/f...tomfilter.html

2. http://allenbrowne.com/ser-62.html

[bronson_mech]

Thanx June7 the tutorial which u uploaded it really helpful for me....... now i one problem that i can't able to fix it.....
i have created two combo box for filtering 1st for filtering by Material Type(MT) 2nd is for filtering by PR #.
So when i filter by Material Type(MT) it gives me a list of result, later on i need to filter that result with PR # and i also did it its working...
but the problem is when i click on MT it gives me a list of result and when i click on PR it should only show the list of PR # which is available in the result instead it showing all PR# in that table....

[June7]

Sounds like you want dependent (cascading) comoboxes. Review http://datapigtechnologies.com/flash...combobox2.html

[bronson_mech]

Thanx a lot June7 i almost completed my project, i'm in the final stage i have some issue in this database, i want to capture the issued qty in this material tracking sheet..... once i enter the qty in material issued form it should auto populate in material tracking according to its reference ID....... i tried to link it in default value but its not working, giving me #name? error so can u please help me out to fixing this issue....

[June7]

I don't understand why data needs to be in two tables. Review http://allenbrowne.com/AppInventory.html

[bronson_mech]

do u have any other solutions bcos i'm getting to many errors.

[June7]

What are the error messages? What are you attempting when they trigger?

[orange]

Can you post a jpg of your tables and relationships?