Lookup problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a lookup using the combo box wizard in Access 2003. Everything
works just fine for the first few times, I can start entering new record data
and the type ahead or whatever you call it starts helping me fill out the
information. I can also use the drop down arrow and pick a name from the
list, but with thousands of names, this a tough way to go. The problem is
that after a few times using the form, this feature no longer works and I
cannot even type in a correct name - but the drop down list still works. Any
idea of what is going on?
 
Do you receive error messages or something? If you recreate your combo box,
will it work again for a few time and stop working after?

I do not see why this is happening.

Yanick
 
I did some research and the limit for a combo box is 65536 item. I hope you
are not exeeding this number.
 
At first I do not get an error message or anything. It just stops working
properly. If I recreate the combo box, it will work again for a few times,
then only allow selection from the drop down box, not any type-in entry's -
even if they are listed in the drop down list. At that point, I do get a
message that says this is not on the list (when it is) Regarding your 2nd
thought - I do not exceed the 65536 number.
 
It look like the Locked properties goes to Yes by some way. If you right
click on the combobox in design mode then on properties, you should see the
Locked propertie in the data tab. Check if it is set to Yes.
 
No - it was set to "No". Just for fun, I tried setting it to "Yes" and I
could not even select from the drop down list. What is really strange, is
that when I type in an entry that is on the drop down list, I get an error
saying "The text you entered isn't an item on the list" (but it is)
 
I am having the very same problem. The first few times, the autofill for
typing in an entry works, and then stops working. The entry must be selected
from the drop down list, even when I type in the exact value. (I copied and
pasted the value from the drop-down table source to ensure I had the exact
entry). I am using Access 2003 SP2.

Any suggestions on how to resolve this so that the entry can be typed in the
control and not forced to always pick from the drop down. Thanks!
 
I was able to resolve this problem by doing the following:
a. Remove the combo box control from the form. Save the form.
b. Compact and Repair the database.
c. Reopen the form in DESIGN mode. Open toolbox.
d. Manually add a new combo box on the form. I followed the wizard to
define the source table for the drop down and other properties.

The combo box appears to behave as expected now and I no longer have to
select the entry from the drop down, but can enter values in the text portion
of this control.

I don't know why this control started to ignore the set properties, but
removal and recreating appears to resolve the issue.
 
Lynda said:
I am having the very same problem. The first few times, the autofill for
typing in an entry works, and then stops working. The entry must be selected
from the drop down list, even when I type in the exact value. (I copied and
pasted the value from the drop-down table source to ensure I had the exact
entry). I am using Access 2003 SP2.

Any suggestions on how to resolve this so that the entry can be typed in the
control and not forced to always pick from the drop down. Thanks!
Click to expand...

I took Lynda's suggestion and it helped somewhat. The drop down arrow works
and allows me to select a name, but the type ahead feature still does not
work properly. The form I am creating has 3 fields using the combo box
feature - the 1st box always works just fine. The 2nd and 3rd work, but not
quite right. The strange thing is that all 3 work fine when I first create
them, but after closing and re-opening the program, the 2nd and 3rd boxes
quit allowing the type-in feature. The is a problem as I am working with
about 2,000 names. Could it be the combination of the number of records in
the 1st box plus the 2nd etc exceeds the max. If so, why does it work the
first time?
 
Back
Top