greying out cells

[Mturner]

ill simplyfy this problem to make it clearer.

i have 2 tables, one is tbl_types the other is tbl_info

a feild in tbl_indo gets info in a drop down box from tbl_types.

in the tbl_info there are feilds such as monitor serial number base serial number fdd working etc, what i would like to do is when i have selected from the dropdown list something like printer, i would like some cells to be grayed out and not usable, eg if i am entering some info about a printer i do not need the feilds such as monitor serial number and fdd working etc, is there a way to do this?

if you need me to expand more just ask, i could send you the database if you fancy a task!.

thank you very much

Marc Marc Turner
Network Manager

E-Mail: Mturner@turnerm3.fsnet.co.uk

 

[mp9]

Use the drop-down's AfterUpdate event to dynamically set the Enabled property of the controls you want to disable/enable.

http://www22.brinkster.com/accessory/

 

[Frink]

Hallo,

This sort of thing has to be done in a form. (I only mention that because this post is in a Tables forum)

If the combo box is on a form then:

in the combo box AfterUpdate event, put the following code:

With Me
  Select Case !cboType
    Case "Printer"
      !SerialNo.Enabled = True
      !FDDWorking.Enabled = False
    Case "Base Unit"
      !SerialNo.Enabled = True
      !FDDWorking.Enabled = True
  end select
end With

Hope that helps,

- Frink

 

[Mturner]

frink i think that will, ill try it when im next working on the database, i am doing it in a form, but only did a search for access.

thanks! Marc Turner
Network Manager

E-Mail: Mturner@turnerm3.fsnet.co.uk