Cascade comboboxes again... :)

[gostap]

Sorry, I post the wrong database....

strippedIII.zip

[ssanfu]

Sorry.. My bad...

When using DoCmd.OpenReport , one of the parameters is a "WhereCondition"

WhereCondition

Optional

Variant

A string expression that's a valid SQL WHERE clause (WHERE clause: The part of an SQL statement that specifies which records to retrieve.) without the word WHERE.

I modified the code for "cboAssist_AfterUpdate" and now the report opens as it should.

I also deleted most field captions in the table.
I added "Option Explicit" at the top of EVERY MODULE. There were undeclared variables and missing double quotes.
You have a field names "Kontakt(tel)" - this is bad because of the special characters.

You should remove all Look up FIELDS (in tables)... Reason: http://access.mvps.org/access/lookupfields.htm

[gostap]

Thanks a lot all of you! Works perfectly now!
Again, thanks!

[ssanfu]

We're all happy to help...