Search results

actually the filter works when there is result(s), if there is no result it gives me this error. I use the function "CheckFilter" for some other entries it works fine, when it can't find any match just returns a blank page instead of an error.

How do I modify that? Thanks

I keep getting an error: run-time error '2185' "you can't reference a property or method for a control unless the control has the focus." There is no problem with CheckFilter function, I checked. My Code: Thanks

I need both tables for other purposes though. Even if I merged them into one table like the one you showed, it still is a recursive table. When you filter a certain ItemID, it only returns it's corresponding ItemName but not all items fall in to this parent item.

I have a table set up like this ClassID (pk) ClassName ParentClassID And of course another like this ItemID (PK) ClassID (FK) ItemName for example, ClassID ClassName ParentClassID 1 .........Vegetable.......null 2 ......... Meat............ null 3 ...

yep, got it done already. thanks for your help!

problem solved! works perfectly! it's easy. just set the level2 subform control's LinkMasterFields to: Forms![main form].[equipment id];[Component type id] and the LinkChildFields property to: [Equipment id];[Component type id] I didn't know I can do this.

There was no join between component type (general) to equipment (specific). :) so I guess my structure was correct.:D This is what my form looks like as you can see I put 2 tables "equipment" and "equipment type" in my main form. it contains all the info about each "specific" equipment...

If you take a look at the screenshot I uploaded. Please :) table "equipment" and "component" are connected with 1 to many relationship. thats for "specific" Table "equipment type" and " component type" are connect with 1 to many as well, thats for "general" Table "equipment typ" and...

Thanks for the greeting and quick response! What I'm trying to do here is to predefine a model. Equipment type and component type need to be built first, so after that when I defining a equipment as soon as I assign it's equipment type it knows associated components ( through...

I created a form that contains 1 subform ( lets call it lvl 1 subform) in which I created another subform( lvl 2 subform). lvl 1 subform acts like a child to the main form, works well, it returns each equipment's corresponding component type. lvl2 does the same, returns all component...