combo box dropdown

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I currently have a combo box on a form which is locked except during new
records:

If Me.NewRecord Then
Me.cboHANAME.Locked = False
Else
Me.cboHANAME.Locked = True
End If

I would like to also prevent the dropdown form working except during new
records ...
How do I do this?
 
An alternative to the code below:

Me.cboHANAME.Locked = Me.NewRecord

Since Me.NewRecord evaluates to a TRUE/FALSE value, you can apply it
directly to the .Locked property.

If you do not want the dropdown list to be "touched"/"moveable", etc, then
set the .Locked=TRUE and .ENABLED=FALSE.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top