Coloured fields, access rights, open forms depending on subform

[AccessWillKill]

i've been issued with a new problem now and i was wondering if you could help me.

Firstly apologies if i am breaking any forum rules, or if this can be done without VBA.

I've got a form. The form is a searcher.

It uses 2 drop boxes and a set of radio buttons to pull up fields in a subform. This i should be able to do, however i've been given other parts that make it more complicated.

1) the subform has an entity based on one of the three main form drop boxes. this is a status. Is it possible to shade records on the subform a colour depending on what the status is?

Like if status is pending colour = blue
if complete status = red
if open = yellow

2) When you click on a record in the subform it opens up a new form with fields to view the full record set (one of the fields is a memo field so it doesn't make sense to have it held in the subform)

3) depending on the users right (3 levels, green red and yellow) and the level of the form (again same three levels) certain textboxes are enabled so...

green level users can edit nothing
Yellow level users can edit some but not all
Red level users have full access

ideally i'm waiting part 3 to be in a module because it would come in handy for other forms.

this is what i'm researching. input is greatly appreciated. again sorry if i've broken forum rules, or if this shouldn't be posted in the VBA posts.

 

[SpentGeezer]

All this can be easily done. Need your database to be able to give you any VBA though.

 

[AccessWillKill]

I actually have the first and third parts done. the second part i think i have the answers for as well. I'll let you know over the next week, one way or another.

I was making things alot more coplicated than need be.

thanks all the same though