Strange combo box problem

[kfulton]

I've got a combo box that gets it's lookup from a table. When I click on the little down arrow and choose from the list, everything is fine.

But, if I start typing in the field (without first clicking on the little down-arrow), it will fill in for me (for example, if I type "Mic", it will fill in the rest "Microsoft Internet Explorer", then if I hit <enter> it goes into the field... no problem, right? Well, THEN, I am unable to ever click on the little arrow for the combo box ever again. Not to change that item, not to add a new item, it won't ever let me use that combo box again. I have tried rebooting and everything!! When I go to the next record, I can use it fine, but for that record, it won't let me use it! What's up with that???

 

[Dave Eyley]

Well I would say that you had a problem with the Combo.
I tried what you did and could not repeat the fault so the options are -

1. It's the Combo - delete the combo and do it again....
If not -
2. It's the Form - delete the form and do it again (Don't cut and paste anything as you might transfer the problem too)
Failing that -
3. It's Access - Bad news! Uninstall Access and re-install and then try the same form.

Other than that - there's not a lot else to try.....

Good Luck

Dave E

 

[Rich]

Have you set Allow Edits to no?

 

[kfulton]

Where would I find Allow Edits? I went in and changed Allow AutoCorrect to no, not sure if that helped any. But it seems now that this is happening:

Let's say I have WinZip 7.5 and WinZip 8.0 in my drop down list.

If I start typing "Win", it'll fill in with "WinZip 7.5". Then if I arrow over to the end of the line and delete "7.5" and type "8", it'll fill in with "8.0", but then I am not allowed to use the combo box anymore for that hard drive to add new software or change a software entry. But, if I delete the offending record, then I can use the combo box again.

 

[Hayley Baxter]

Allow Edits is in the form properties under the data tab.

The Autocorrect property repairs the following: (Taken from access help)

Name AutoCorrect fixes all discrepancies that occur when you rename any forms, reports, tables, queries, or controls on forms and reports. If you create forms or other objects while Name AutoCorrect is turned off, then when you turn Name AutoCorrect on, Access will fix any new discrepancies as you continue working with the objects. If one of the objects already has a renaming error when you turn Name AutoCorrect on, you will have to fix references to the object manually. For forms or reports that contain Visual Basic code, Access repairs references to the form, but does not repair references to objects in the Visual Basic project.

Hay

 

[kfulton]

Combo box problem

Argh. I will try that, but now it seems that it doesn't want me use the drop drop down list to add more than 5 records. I can use it for the first 5 and then it goes away. But I can still add more records by typing in the field, it just won't let me use the drop down box.

 

[Hayley Baxter]

Did you try re creating the combo box from Scratch? I would think this would resolve your problem.

 

[kfulton]

I haven't tried that, but I don't know what I would do different. I don't really know how to code the events so I would just be typing in word for word what's already there...

I have another event script that I can try, but I tried several I found on the web and non of them worked. The only reason I have this one working is because I begged our database guru to come over from the other building and fix it for me...

 

[kfulton]

Strange combo box problem, allow edits

Allow edits is set to yes, which I think is the way I want it....

 

[llkhoutx]

I recall having a similar problem with a combo box which was improperly bound to a table field. Check you combo box's properties and see how its bound.

 

[kfulton]

strange combo box problem

okay, I will check that. I tried recreating everything and still get the same problem.