enable check box on read only form?

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

Like Tore I don't really understand most of what you're saying. I doubt that
being in Edit mode has anything to do with the error being thrown.

It would help people here to help you if you

1) Posted the error message

2) Posted the code you're using for this task

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200911/1