Topic: Change behavior of fields in another form based on id of another table
Good evening,
I'm scratching my head over one bit tricky problem that I'm facing these days.
I've tried numerous solutions but I didn't manage to find a correct way.
So first things first we have 3 tables (models, modeltypes, meters) and 3 different forms. Now what I want to do is when a combobox on form 3 (meters) which is for the model name that has a specific model type changes based on the selection, I want to hide a specific field(s) on form 3, i.e. if the modeltype is black and white then hide the field on form 3.
I attach a sample project to be more helpful.
(It contains another forms and tables I was experimenting, but the forms that I want to work are form4, form5 and form6)
Thank you for any advice and help anyone can provide.