.frmLISTBOX.Enabled = False NOT working

[RogerTunnicl]

I am having trouble with frmFORM.frmLISTBOX.Enabled = false
It does not work in one particular section of code and I am going to make a guess here. The code is called from frmLISTBOX_Click and I am guessing that you cannot disable a list box while processing it. It's odd though that .frmLISTBOX.Visible = false does work in the same section of code. Can anyone enlighten me ???
If I am right how do you disable a ListBox after a selection has been made. ie a record is being selected to be modified, the controls are enabled and the form awaits input.

[:) Sixthsense :)]

ie a record is being selected to be modified, the controls are enabled and the form awaits input.

I am unable to understand your expectation

[RogerTunnicl]

I have a data entry form which contains a listbox at the bottom. It displaysall records in the file. By clicking on the listbox a record is selected, displayed on the form and the fields are enabled to allow data entry. Additionally I want the list box to be disabled while the data is entered and saved. (This seems to work OK in OpenOffice)

[:) Sixthsense :)]

How about adding your code in the OnExit Event of frmLISTBOX? Because once the user selected the item and when he moves to next control then the Listbox will get disabled.

Please Login or Register  to view this content.

Is this helpful?

[RogerTunnicl]

Could not find the event you are describing but coded the following:-

Tran Type is the first data field on the form after the user has entered a Key value and is then adding or modifying a record

Sub frmTRANTYPE_Enter ()
.frmLISTBOX.Enabled = False

' .frmOZ.Enabled = False
' .frmOPENPRICE.Enabled = False
' .frmCLOSEPRICE.Enabled = False
' .frmPL.Enabled = False

End Sub

It works for every field on the form EXCEPT the LISTBOX
Disabling the listbox does however work when control travels through a different part of the program. ie When the user selects the ADD function

It's got me beat !!!!

[RogerTunnicl]

by the way, do you know where I can find all the sub names that relate to events on a form (field). ie:-

frmTRANTYPE_Click()
frmTRANTYPE_Enter()

etc

[Norie]

If you select a control in the left hand dropdown above the code window you'll find all it's events listed in the right hand dropdown.

When you select event you should see the code stub for that event.

For example if you had a listbox called frmLISTBOX select in the left hand dropdown and then selected Exit from the left dropdown you would see this.

Please Login or Register  to view this content.