Hello there,

I'm creating a db for real estate.

I created a page "clients" with some general info...

I also created 2 subforms. One should be used for the terms of research of a client who is looking for a property (Max price, Min sum ....). The second one for the owners who would like to sell their property (Sqm, floor, bedrooms, floor).

When a client is an owner, the system should hyde the subform for the research. When a client is looking for something, it should hyde the Owner subform.

I'm using subforms and not look up fields and I don't know how to hyde subforms on certain conditions.

Thanks