See more fields after selection of particular item in combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I’ve searched your groups for days but am unsure of what to look for in the
Search for what I’m trying to do. If anyone can point me in the right
direction, I’d appreciate it.
In Access 2000 I’m working on a form with 3 subforms. All are used for data
entry. One field on the tblAddressChange subform is a cboRequestor. There
are 4 selections in the combo, one selection is ‘Provider’. Is it possible,
upon selection of ‘Provider’, to ‘ungrey’ 2 fields, [AName] and [APhone] and
enter the ProviderName and Phone which will then be added to the
tblAddressChange of which the subform is based on? The main form is based on
qryChecks, the subform on tblAddressChange and the cbo is based on
tblRequestor. All are There will be 3 continuous view subforms on this main
form. If this is not possible, are there any suggestions?
 
So, you have a continuous form with several cbos, and you want some cbos to
be "greyed out" depending on the state of one cbo on their line?

If "greyed out" means ".Enabled = True or False", I am affraid this is not
possible. If it is simply about the color, you can use conditional formating.

Or am I wrong?

- Igor
 
Or did I misunderstand you?

Basically, the control properties are shared by same control on all records
on a continous form.

But if I misunderstood you, and the cbo with ‘Provider’ and cbos that needs
grey-out are not on a continuous form (or sub-form, does not matter), then
you can use the basic "AfterUpdate" event handler of the ‘Provider’ cbo to
enable or disable other controls.

- Igor
 
No, you understood perfectly. It didn't sound like a logical request to me
since they are using a continuous form but I wanted to thoroughly research
before I told her it couldn't be done. I'll just put the 2 fields at the very
end of the other fields.
Thanks for your reply

Igor said:
Or did I misunderstand you?

Basically, the control properties are shared by same control on all records
on a continous form.

But if I misunderstood you, and the cbo with ‘Provider’ and cbos that needs
grey-out are not on a continuous form (or sub-form, does not matter), then
you can use the basic "AfterUpdate" event handler of the ‘Provider’ cbo to
enable or disable other controls.

- Igor

kelli said:
I’ve searched your groups for days but am unsure of what to look for in the
Search for what I’m trying to do. If anyone can point me in the right
direction, I’d appreciate it.
In Access 2000 I’m working on a form with 3 subforms. All are used for data
entry. One field on the tblAddressChange subform is a cboRequestor. There
are 4 selections in the combo, one selection is ‘Provider’. Is it possible,
upon selection of ‘Provider’, to ‘ungrey’ 2 fields, [AName] and [APhone] and
enter the ProviderName and Phone which will then be added to the
tblAddressChange of which the subform is based on? The main form is based on
qryChecks, the subform on tblAddressChange and the cbo is based on
tblRequestor. All are There will be 3 continuous view subforms on this main
form. If this is not possible, are there any suggestions?
Click to expand...
Click to expand...
 
Back
Top