conditional entry

[feri]

There is a check box (Field C requiring mailings to a different address) and
there is Field D for the different address. What is the best way making
sure that someone can enter data only into Field D if Field C is "checked
on"??
Thanks,
Feri

 

[John Spencer]

As far as I know you can only control this on forms.

If you are using Access 2000 you can use conditional formatting on the
control that is bound to field C.
-- In design view, click on the control
-- Select conditional formatting from the format menu
-- Change "Field Value is" to "Expression is"
-- Enter text like [NameofCheckBox] = False
-- Click the last button in the conditions options (enable/disable)
-- Click OK
TEST and see if it works.

If you are doing this in earlier versions of Access, you will need VBA code
to do the same thing. You will need to run the VBA in the form's current
event and the control's change event. That bit of code would look like

ME.[AddressControl].Enabled = Me.[NameOfCheckbox]