Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub lstData_Click()
Me!lstEvents.RowSource = Me!lstEvents.RowSource & "On_Click;"
End Sub
***********************************
* Main Setup #1 *
***********************************
* RowSourceType: Table/Query *
* RowSource: Table/Query Has Data *
***********************************
Click an Item DbClick an Item
-------------- ----------------
On_MouseDown On_MouseDown
On_MouseUp On_MouseUp
BeforeUpdate BeforeUpdate
AfterUpdate AfterUpdate
On_Click On_Click
On_DblClick
On_MouseUp
Click a Header DblClick a Header
or Empty Space or Empty Space
under last Item under last Item
--------------- -----------------
On_MouseDown On_MouseDown
On_MouseUp On_MouseUp
On_DblClick
On_MouseUp
************************************
* Main Setup #2 *
************************************
* RowSourceType: Table/Query *
* RowSource: Table/Query No Data *
************************************
Click Anything DbClick Anything
-------------- -----------------
On_MouseDown On_MouseDown
On_MouseUp On_MouseUp
On_DblClick
On_MouseUp
*******************************
* Special Case #1 *
*******************************
* RowSourceType: Value List *
* RowSource: Has Data *
*******************************
Me!ListBox.Selected(1)=True
Works . . .
Me!ListBox.Selected(1)=False
Does not.
*******************************
* Special Case #2 *
*******************************
* RowSourceType = Table/Query *
* RowSource is Blank/Empty *
* Column Heads : No *
*******************************
Dim Lbx As ListBox
Set Lbx = Me!YourListBoxName
If Lbx.Selected(Lbx.ListIndex) Then
'Your normal code here
Else
'What you want do do if listBox is empty!
Endif
Set Lbx=nothing
If Len(Me.RowSource & "") > 0