combo box not showing all options

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

Guest

Here is an oddity I have had happen in the last couple weeks. I have a form
that allows an employee to select a department from a combo drop down box and
run a report to see who has trained there. In the last couple of weeks,
sometimes the dropdown box will not show anything past the C's, or basically
what you can see when you click on it before you can scroll down. If you
wait and click off of it and go back, it will usually then work correctly.
Any ideas of why it would do this, and why it would have just started?

The box is set to look up from tblDepartments and pull the DeptID and in the
criteria it is set to Not In "Adm", basically restrictiing it from pulling up
the Adm department.
 
How many rows are there in the table where you get the department?
Has there recently been an increase in the number of departments?
Is the row source doing anything like SELECT DISTINCT or an domain aggragate
functions?
Has your network been running slowly or had any configuration changes that
might adversely affect your performance?

The reason I ask, is that, based on your description of the problem, it
appears the rowsource has not been fully populated. That is because you said
you could go back to it later, it it would work fine.
 
29 rows should be almost instantanious. This is puzzling. Are you having
any other performance issues? Also, what is your configuration? I mean is
it an mdb or SQL Server? Are you using a split database? If you are, does
each user have his/her own copy of the front end on their computer. If you
only have one mdb will the application and the data and it is in a shared
folder or you have a split database, but every user is sharing the same front
end, then that could be an issue.

Is every user experiencing the problem, or just some?

One other thing you could try, assuming you are correctly configured, it to
relink all your users. It may make no difference, but since the desktops
have been changed out, there could be some network, or desktop configuration
issue contributing to this.
 
Here is my row Source

SELECT tblDepartments.DepartmentID
FROM tblDepartments
WHERE (((tblDepartments.DepartmentID) Not In ("ADM")))
ORDER BY tblDepartments.DepartmentID;

The table it pulls from is only 29 rows and nothing has been added to it
lately. I don't know if they've done anything recently to our network, I do
know last month we got new desktops, but the server has stayed the same. It
is odd, because you can still type in the initials of the department in the
combo box and it will finish it as you start typing, but it will still not
show all the departments if you pull down the scroll box again. But then if
you click off it and try again, it usually will.
 
It is a mdb database, and they are split, each computer has a front end. I
had it occur on my computer as well as a couple of others here. It hasn't
happened recently..not sure what the deal is. I did recopy the front end
back over to the computers, so maybe that fixed it. I keep a unlocked
version on my computer as well as a backup copy on the server that only I can
access. I then change that to locked and distribute it.
 
I would check my references in VBA Tools, References. If you have new
desktops, you can't be sure that your Office products were installed exactly
as they were before or that a complete install was done.
 
Ok I'm kind of lost on what that means. Are you meaning just check the
reference list to make sure things are there and checked?
 
That is correct. It will need to be done on each user's computer.

The other point in my post is that when you install Office, there are many
different options on what and where things will be installed. I have found
that sometimes they are not consistent. I know, for example, here the
installs are done by our desktop support group. Some of their people will do
a complete install and others will do the "recommended" install which does
not include eveything, so some DLL's, for example, are not installed. When
we went from 2000 to 2003, we had problems with this.
 
Back
Top