Look up list problem-Help

M

MrsShelliB

I have a database that looks information up from several tables to supply a
truck loads information. It looks up to the truck table for truck numbers and
up to the agents table for the agents code. I used to be able to drop down
the list to get to CGV by hitting the C key and it would go to the C's then
hit G and it would drop down to CG. Now it does nothing but tell me the item
is not in the list. And when you have 1500 to scroll through scrolling down
can be time consuming. I have recreated my tables, recreated my forms,
everything. I originally thought it was just an error in my forms, but it
doesn't work in my tables either. How do I fix this.
 
M

MrsShelliB

I don't know where my glitch is, but it is in all of my databases. My Auto
Expand is set to Yes. I was messing with it yesterday and as long as I go
into design view, delete just any one of the combo boxes and recreate it they
all begin to work. I love the 10 commandments. Will heed them. But what is an
alternative to Look up Fields if we are supposed to abhor them? Maybe that
would eliminate the problem.
 
W

Wayne Morgan

The 10 Commandments is referring to lookup fields in a table. Tables are
just big buckets to hold your data. The lookup should be done on a form.

I'm going to take a guess here. Go to Tools|Options, on the General tab,
uncheck Perform Name Auto Correct and Track Name Auto Correct Info.

Where are the database files located? Are they on the local hard drive or
across a network?
 
M

MrsShelliB

The database is contained on one computer on a local hard drive, not over the
network. I unchecked both boxes and it does not fix the problem. I still have
to delete just any one combo box and recreate it and they work. I wonder (now
this may be stupid, but...) could it be a flaw in the programing or visual
basic. I have done a detect and repair, Even reinstalled Office altogether,
and have the same flaw in any database I open.
 
W

Wayne Morgan

What happens if you open the database on another computer? Since you say it
is in all of your databases, I wouldn't expect creating a new database and
importing the object to help.

Could it be a flaw in the VBA code? Yes, but I wouldn't know where to look.
A good place to start looking would be any code in your startup form or any
code run by an Autoexec macro.
 
M

MrsShelliB

Whatever it is in inside my database. I copied the entire database onto
another computer and it still does the same thing. I appreciate the thought
though.
 
Top