Problem with Drop Downlist

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

I am having problems with the drop down list object. To select an item I have
to use the Tab key. If I click it with the mouse it doesn't select the item.

This is happening on several databases and I am not sure what is the cause -
does anyone have some things I can check?

Thanks
Matt
 
R

Ryan Clair

Trying to understand this.

You can tab to it and arrow down and select the options listed in the
combo box but not use the mouse...?

Also will need to know the query of the combo box (row source).
 
M

mattc66 via AccessMonster.com

Sorry for not being clear..


The combo box source is determined by the selection of the company in a prior
ComboBox Event (see example).

Private Sub CompanyID_AfterUpdate()
Dim stEmp As String
Dim stCoNum As String

stCoNum = Me.COMPANY

If stCoNum = "C1" Then
stEmp = "qryLookupSalesEmp_C1"
ElseIf stCoNum = "C2" Then
stEmp = "qryLookupSalesEmp_C2"
End If

Me.Salesperson.RowSource = stEmp
End Sub

After the Company has been selected the ComboBox "Salesperson" is populated.
If I click on the ComboBox with the mouse I can see the correct list, but
when I then click on the person it doesn't select them. However if I use the
arrow down key and then use the tab key while on the correct name, it works
fine.

Ryan said:
Trying to understand this.

You can tab to it and arrow down and select the options listed in the
combo box but not use the mouse...?

Also will need to know the query of the combo box (row source).

I am having problems with the drop down list object. To select an item I have
to use the Tab key. If I click it with the mouse it doesn't select the item.
Click to expand...
[quoted text clipped - 10 lines]
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1
Click to expand...
Click to expand...
 
R

Ryan Clair

Does the combobox have a control source?

Ryan


Sorry for not being clear..

The combo box source is determined by the selection of the company in a prior
ComboBox Event (see example).

Private Sub CompanyID_AfterUpdate()
Dim stEmp As String
Dim stCoNum As String

stCoNum = Me.COMPANY

If stCoNum = "C1" Then
stEmp = "qryLookupSalesEmp_C1"
ElseIf stCoNum = "C2" Then
stEmp = "qryLookupSalesEmp_C2"
End If

Me.Salesperson.RowSource = stEmp
End Sub

After the Company has been selected the ComboBox "Salesperson" is populated.
If I click on the ComboBox with the mouse I can see the correct list, but
when I then click on the person it doesn't select them. However if I use the
arrow down key and then use the tab key while on the correct name, it works
fine.

Ryan said:
Trying to understand this.
Click to expand...
You can tab to it and arrow down and select the options listed in the
combo box but not use the mouse...?
Click to expand...
Also will need to know the query of the combo box (row source).
Click to expand...
I am having problems with the drop down list object. To select an item I have
to use the Tab key. If I click it with the mouse it doesn't select the item.
Click to expand...
[quoted text clipped - 10 lines]
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1--
Click to expand...
Click to expand...
Matt Campbell
mattc (at) saunatec [dot] com

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1
Click to expand...
 
M

mattc66 via AccessMonster.com

Yes, the Control Source is: Salesperson

Ryan said:
Thats the rowsource. This is the Control Source (just below the name).

Ryan
by default no - it gets set by the code I had in the example.
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
R

Ryan Clair

And using the arrows, it does change the value in Salesperson field in
the table?

I've actually never used control source before for a form that the user
updates so I don't know the behavior (try removing it and see if there
is a difference?). Usually I run an update (or append) query.

Ryan

Yes, the Control Source is: Salesperson

Ryan said:
Thats the rowsource. This is the Control Source (just below the name).

Ryan
by default no - it gets set by the code I had in the example.
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
Click to expand...
 
Top