enable check box on read only form?

  • Thread starter Thread starter EddWood
  • Start date Start date
E

EddWood

I have a form that opens a list of invoice items and have it set to open in
edit mode, as the users are allowed to select items from the invoice to
dispatch via a checkbox.

The problem I have is, in edit mode if the user selects a check box with no
line items, it throws an error message. So what I want is a way I can open
the form in 'read only' with the exception of the check box, so the users
can select items to dispatch.

Cheers
 
It is hard to fully understand your problem from your description.

May be you could trap the error by using the check box "before update" event
in vba-code. This event runs before the checkbox is actually updated, and it
allows you to to write vba code that checks if any "line items" exist. If
not, the "before update" procedure could cancel the update and prevent the
error.

If the checkbox is in a standard form you could use vba-code to make it
invisible (Me.checkboxname.visible = False) if it cannot be updated. This
will not be possible in a datasheet form. Or I guess you could also use the
locked property (Me.checkboxname.Locked = true/false).

Tore
 
Back
Top