subform - 2nd question

Hi

I have made my first steps with subforms and I am sattisfied
What I don't know how to is following :

On my main form I have Subform (created with wizard) based on continuous
form. I'd like to have some fields disabled related to some related value.
For example :

Select Case TRX_Type
Case Is = "dTRX"
Ctl2x06_Mode.Enabled = True
Case Is = "EDGE dTRX"
Ctl2x06_Mode.Enabled = True
Case Else
Ctl2x06_Mode = " "
Ctl2x06_Mode.Enabled = False
End Select

I need something which will "Scan" all xyTableID's and if it finds some
previously satisfied rules than to change related fields properties, and
present it in that way on subform.

Something like

For Each tableID In xyTable
Select Case....
Next

Is it possible to do it somehow?
Thanks

I explained too complicated.

Is is possible to have different background colors in the continuous form
for the same fiels?
If I change background color for one field it is authomaticaly changed for
all same fields.

Thanks
"kiki" wrote in message ...
Hi

I have made my first steps with subforms and I am sattisfied
What I don't know how to is following :

On my main form I have Subform (created with wizard) based on continuous
form. I'd like to have some fields disabled related to some related value.
For example :

Select Case TRX_Type
Case Is = "dTRX"
Ctl2x06_Mode.Enabled = True
Case Is = "EDGE dTRX"
Ctl2x06_Mode.Enabled = True
Case Else
Ctl2x06_Mode = " "
Ctl2x06_Mode.Enabled = False
End Select

I need something which will "Scan" all xyTableID's and if it finds some
previously satisfied rules than to change related fields properties, and
present it in that way on subform.

Something like

For Each tableID In xyTable
Select Case....
Next

Is it possible to do it somehow?
Thanks

The only way to do this in a ContinuousFormView is to use Conditional
Format.

Check Access Help on Conditional Format.

--
HTH
Van T. Dinh
MVP (Access)


"kiki" wrote in message ...
I explained too complicated.

Is is possible to have different background colors in the continuous form
for the same fiels?
If I change background color for one field it is authomaticaly changed
for
all same fields.

Thanks
"kiki" wrote in message ...
Hi

I have made my first steps with subforms and I am sattisfied
What I don't know how to is following :

On my main form I have Subform (created with wizard) based on continuous
form. I'd like to have some fields disabled related to some related
value.
For example :

Select Case TRX_Type
Case Is = "dTRX"
Ctl2x06_Mode.Enabled = True
Case Is = "EDGE dTRX"
Ctl2x06_Mode.Enabled = True
Case Else
Ctl2x06_Mode = " "
Ctl2x06_Mode.Enabled = False
End Select

I need something which will "Scan" all xyTableID's and if it finds some
previously satisfied rules than to change related fields properties, and
present it in that way on subform.

Something like

For Each tableID In xyTable
Select Case....
Next

Is it possible to do it somehow?
Thanks

Does it exist in Access97???

"Van T. Dinh" wrote in message
...
The only way to do this in a ContinuousFormView is to use Conditional
Format.

Check Access Help on Conditional Format.

--
HTH
Van T. Dinh
MVP (Access)


"kiki" wrote in message ...
I explained too complicated.

Is is possible to have different background colors in the continuous
form
for the same fiels?
If I change background color for one field it is authomaticaly changed
for
all same fields.

Thanks
"kiki" wrote in message
...
Hi

I have made my first steps with subforms and I am sattisfied
What I don't know how to is following :

On my main form I have Subform (created with wizard) based on
continuous
form. I'd like to have some fields disabled related to some related
value.
For example :

Select Case TRX_Type
Case Is = "dTRX"
Ctl2x06_Mode.Enabled = True
Case Is = "EDGE dTRX"
Ctl2x06_Mode.Enabled = True
Case Else
Ctl2x06_Mode = " "
Ctl2x06_Mode.Enabled = False
End Select

I need something which will "Scan" all xyTableID's and if it finds
some
previously satisfied rules than to change related fields properties,
and
present it in that way on subform.

Something like

For Each tableID In xyTable
Select Case....
Next

Is it possible to do it somehow?
Thanks