Hiding Combo Box

[Dave]

I have created a few forms in Access 2000. Each form has a combo box with
refNo, forenames and surnames that select a record in that form. I have put
two buttons that go to another form (from the main form). The first goes to
all records, the second goes to a specific record. Is there way to disable
the combo box (on the 2nd form) when I select a specific record from the
main form. As it has no use when going to a specific record. I have limited
knowledge of coding I would guess that coding is needed for this problem.

[MGFoster]

Dave wrote:

I have created a few forms in Access 2000. Each form has a combo box with
refNo, forenames and surnames that select a record in that form. I have put
two buttons that go to another form (from the main form). The first goes to
all records, the second goes to a specific record. Is there way to disable
the combo box (on the 2nd form) when I select a specific record from the
main form. As it has no use when going to a specific record. I have limited
knowledge of coding I would guess that coding is needed for this problem.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Enabled property of the ComboBox.

When you want to let the user use the ComboBox:

On the current form:
Me!ComboBoxName.Enabled = True

On another form:
Form!FormName!ComboBoxName.Enabled = True

Change "True" to "False" when you DON'T want the user to use the
ComboBox.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQh993YechKqOuFEgEQJsFgCg+SHom+YR0O27Calz4najwD guDvMAoIAT
JsM6pnA9q34WJrUIFyB4+5iL
=VIBJ
-----END PGP SIGNATURE-----