If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
enable check box on read only form?
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 |
#3
|
|||
|
|||
enable check box on read only form?
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 |
Thread Tools | |
Display Modes | |
|
|