Problem with Drop Downlist

[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

 

[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).

 

[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.

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.

[quoted text clipped - 10 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1

 

[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.

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.

[quoted text clipped - 10 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1--

Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1

 

[mattc66 via AccessMonster.com]

by default no - it gets set by the code I had in the example.

Does the combobox have a control source?

Ryan

Sorry for not being clear..

[quoted text clipped - 40 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1

 

[Ryan Clair]

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.

Does the combobox have a control source?

Ryan

Sorry for not being clear..

[quoted text clipped - 40 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1

 

[mattc66 via AccessMonster.com]

Yes, the Control Source is: Salesperson

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.

[quoted text clipped - 13 lines]

 

[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

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.

[quoted text clipped - 13 lines]