enable check box on read only form?

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
 
T

Tore

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
 
L

Linq Adams via AccessMonster.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top