I use MS ACEESS, Category1 is dropdown and all statuses is text boxes...

I have the following problem I have Ddata like

Acc#345..
Category1 Status1 Status2 Status3
Category2 Status1 Status2 Status3
Category3 Status1 Status2 Status3
Category4 Status1 Status2 Status3
Category5 Status1 Status2 Status3

It is all populated through continues for from a database

For each account i have certain categories...

For example for Categgorie1 I need to fill status1 and 2 but not 3
So I want line to look like

Category1 Status1 Status2 (Status3 invisible)

Each record have multible categories. so i want it to look like this

Category1 Status1 Status2
Category2 Status1 Status3
Category3 Status1 Status2 Status3
Category4 Status1
Category5 Status2

I tried to use simple if statements, but when i do status3(f.e) unvisible it becomes unvisible for every category......

Apriciate your help....