X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Cannot Select An Item In A Combobox, Access 2013    
post Dec 3 2019, 12:03 PM

Posts: 121
Joined: 10-January 17

Good afternoon fellow UA'ers!

Working through a DB that was provided by a colleague and testing out the functionality I'm experiencing one minor issue of rather significant importance. When attempting to select an item from a combobox (Access Level), it will not allow me to select any item from the combobox.

the following list property settings for the combobox:

Control Source: Access_Level
Row Source:SELECT qryAccessLevel.Access_Level, qryAccessLevel.Access_Instructions_abr, qryAccessLevel.Sort_Order FROM qryAccessLevel ORDER BY qryAccessLevel.[Sort_Order];
Row Source Type: Table/Query
Bound Column: 1
Limit to List: No
Allow Value List Edits: Yes
Enabled: Yes
Locked: No

within the Event properties:
On Got Focus: [Event Procedure]

Private Sub Access_Level_GotFocus()
If Forms![Check In/Check Out]![txtLocked] = -1 Then
Me.Access_Level.Locked = False
Me.Access_Level.Locked = True
End If
End Sub
Can someone help express this in laymans terms?

Not quite sure what or how to fix this, but suspicion is pointing me to the Row Source? What else should I be looking at?
This post has been edited by MrWrap2: Dec 3 2019, 12:12 PM
Attached File(s)
Attached File  ComboBox.JPG ( 93.79K )Number of downloads: 4
Attached File  ComboBoxProperties.JPG ( 66.81K )Number of downloads: 3
Go to the top of the page
post Dec 3 2019, 12:29 PM

UtterAccess Moderator
Posts: 11,908
Joined: 6-December 03
From: Telegraph Hill

Where is txtLocked in your picture?



David Marten
Go to the top of the page
post Dec 3 2019, 01:28 PM

Posts: 121
Joined: 10-January 17

as if wildly swinging a sword at lifes problems fixes anything....removing the On Got Focus: [Event Procedure] fixed the issue on the surface with no idea/impact to second and third order effects.... guess we'll find out! haha

Thanks all
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    11th December 2019 - 09:57 AM