Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Disabling command buttons when list box contains no records 1

Status
Not open for further replies.
awhitsel

awhitsel

Programmer
Feb 22, 2001
80
US
I want to be able to either disable or make invisible two command buttons on my form whenever there are no records showing in a list box.

I believe that I had brought up this problem once before, but I getting back around to working on this part again.
 
Sort by date Sort by votes
The VBA would be

If ListBoxName.ListCount = 0 Then
CommandButton.Enabled = True
Else
CommandButton.Enabled = False
End If

Where you put this will depend on how you are determining if there is anything in the listbox.

ljprodev@yahoo.com
ProDev
MS Access Applications
 
Upvote 0 Downvote
cmdButton.Enabled = lstListBox.ListCount > 0

If Column Heads of lstListBox is selected Yes then:

cmdButton.Enabled = lstListBox.ListCount > 1

Aivars


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
517
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Output To fails when name contains forward slash 1
Replies
7
Views
222
TrekBiker
TrekBiker
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
430
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
346
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
282
visitnag
visitnag

Part and Inventory Search

Sponsor

Back
Top