Subform filter not working

[zmbd]

parent/child form properties

Becker:

The code tags are fine and helps if the text needs to be copied out (which I did) and they isolate some of the funky charators that the properties can have in them.


"ordering chemicals" has a default filter set, may be a red-herring; however, let's start by removing that filter from the form.

-z

[zmbd]

and that's what I get for haveing to walk away from the post...

The order shouldn't matter unless one is modifying the recordset before the other updates...

at this point I'll need to see the actual database...

can you make a copy, strip the data down to something generic and post the DB?
-z

[Becker]

I removed the default filters on the forms. Not sure why they were there but taking them off didn't change anything. Here is a copy of the database. The form Ordering_Chemic als is the one with the issues. The form Purchasing_Chem icals is a very similar one that does what ordering_chemic als will not. Thanks for your help!

[zmbd]

Becker,

I took only a quick look at the DB you posted. With the way your database is designed, I doubt if you will get this to work. However, I just had a call from one of my site analytical labs that requires me to get the BFH out on an instrument so I won’t be able to really dig much more until later this evening.

In the meantime, I respectfully suggest that you consider starting from scratch. PLEASE understand, I really do mean this as a constructive statement and not with any intent of malice.
You need to read thru this: A Tutorial for Access
And you need to read thru: Database Normalization and Table Structures.
-Z