[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Locked combobox

Posted on 2012-09-11
16
Medium Priority
?
384 Views
Last Modified: 2012-09-16
I've added an unbound combobox to a popup/modal form - but strangely I'm unable to select any of the values in the dropdown. I've tried to restore the form from an old backup, and add the combobox again, but without any luck. Any ideas ?
0
Comment
Question by:Bojerne
  • 7
  • 5
  • 4
16 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38387399
check the forms Allow Edits property, set it toYes
0
 
LVL 1

Author Comment

by:Bojerne
ID: 38387426
Unfortunately it isn't that easy :)

AllowEdits— Yes
AllowDeletions— Yes
AllowAdditions— Yes
DataEntry— No

The form has got some other textboxes and tick/selectbox, that are also unbound that behaves fine - it's only the comboboxes weirdly
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38387439
first do a compact and repair.

test again the combo box..

if problem insists,
can you try creating a new form, add a combo box and check its behaviour..

what version of access are you using?
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38387441
The combobox 'Enabled' property should be set to Yes and 'Locked' property set to No.
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38387448
Check if there are any event procedures (e.g. On Click / Before Update / After Update) for the combobox that might be preventing the change.
0
 
LVL 1

Author Comment

by:Bojerne
ID: 38387453
Enabled is set to Yes, and Locked to No

Compact & repair tried, with no change. I can try and create a new form, but that'll be later today, as the form is a bit complex.

It's version 2003 - but same problem occurs on Access 2010 64bit
0
 
LVL 1

Author Comment

by:Bojerne
ID: 38387470
No event procedures are related to  any of the controlboxes - only the form Open and form Close
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38387478
<but that'll be later today, as the form is a bit complex. >

just try it with few controls ...
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38387519
Another expert exchange user had what looks to be a similar problem:
http://rdsrc.us/RcduMw
What is the row source and row source type?
0
 
LVL 1

Author Comment

by:Bojerne
ID: 38387524
Its evening here - need to feed the kids, and will return a bit later :)
0
 
LVL 3

Assisted Solution

by:Oliver Wastell
Oliver Wastell earned 1000 total points
ID: 38387548
Ditto -you'll probably be back in the office same time as me then!
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1000 total points
ID: 38387560
also, check if you have duplicate values listed in the combo box bound field.
0
 
LVL 1

Accepted Solution

by:
Bojerne earned 0 total points
ID: 38387783
Hmm, finished dinner early - the function calling/openening the form  had a IsLoaded check to see if the for was still open - and that apparently messed up the comboboxes - as soon as I removed the IsLoaded loop everything worked perfectly... go figure :)

Thank you for all your speedy responses.
0
 
LVL 3

Expert Comment

by:Oliver Wastell
ID: 38388287
I'm glad you got it sorted. Thanks for the points ;-)
0
 
LVL 1

Author Comment

by:Bojerne
ID: 38388422
No problem - still can't figure out the logic in that problem, though :)
0
 
LVL 1

Author Closing Comment

by:Bojerne
ID: 38402906
Thank you for the speedy response
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question