Incomplete drop down list

Topic

New Reply

Greetings,

We’re currently running access 2016 split database (with individual front-end and shared back-end)

Couple of questions:

1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the list that is populated is not complete (e.g. provider name that starts with the letter (P-Z) did not show in the list. I checked the tables to verify the provider names are up to date.

a. I checked properties > data tab > Record Source is blank
B. In design mode I also checked properties of the object’s name it shows cboType

2. Though we have a login form where users enter their credentials to log in, we noticed just clicking login will let users access to the application (without entering username & password)

TIA

Regards,

Reply | Quote

Replies

1 – It appears the RowSource for your combo box is the issue – it is likely being updated by VBA code that runs on the AfterUpdate event on the dropdown combo box. May be a bit of a challenge to debug.

2 – Has the application been around a long time and just recently upgraded to 2016? If it has, and you were depending on Access User Security, that feature is no longer supported if you are using the .accdb format for the front-end. Even if the front-end is in .mdb format, the administration of user security is more challenging and more tempremental.

Reply | Quote

Just out of curiousity, how many providers do you have? If there are a lot of rows, Access will delay fully populating a listbox. Just a way of managing resources.

Reply | Quote

It is best for all online forums, including this one, to to limit a post to one topic and question. This help others who use the forum as a knowledge base to search for answers. It also make the thread much easier to follow.

Greetings,

We’re currently running access 2016 split database (with individual front-end and shared back-end)

Couple of questions:

1. We have a form with a drop-down whereby users select either P: Providers or C: Clients to populate the name of the provider or the client. However, the list that is populated is not complete (e.g. provider name that starts with the letter (P-Z) did not show in the list. I checked the tables to verify the provider names are up to date.

a. I checked properties > data tab > Record Source is blank
B. In design mode I also checked properties of the object’s name it shows cboType

First, this is a limit of 64K rows in a combo box’s row source.

Have you check to see haw many rows are getting loaded?

Also see Combos with Tens of Thousands of Records here http://allenbrowne.com/ser-32.html

FWIW: I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode.

2. Though we have a login form where users enter their credentials to log in, we noticed just clicking login will let users access to the application (without entering username & password)

Do you think this is related to the combo box issue?

Reply | Quote

Sorry for the late reply on this. For some reasons, I still do not get a notification e-mail when someone reply to the post. I thought I set up notification already.

We actually have over 72k providers. Obviously, this is the issue as the limit is 65K. I’m trying to adopt the workaround by Allen browne http://allenbrowne.com/ser-32.html

HiTechCoach, I’d like to learn how the following is implemented…

I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode.

TIA,

Reply | Quote

Sorry for the late reply on this. For some reasons, I still do not get a notification e-mail when someone reply to the post. I thought I set up notification already.

We actually have over 72k providers. Obviously, this is the issue as the limit is 65K. I’m trying to adopt the workaround by Allen browne http://allenbrowne.com/ser-32.html

HiTechCoach, I’d like to learn how the following is implemented… “I avoid using a combo box for lists over 1024 (1k) rows. I use a pop-up form in continuous view or datasheet mode. ”

TIA,

Sure.

I use the same technique to show a pop-up calendar and calculator that are both Access forms with only native controls.

FWIW: I first started doing this many years ago with Access 2.0 (Window 3.1). It is the exact same code with only minor changes to update VBA constant names.

To learn more check out this example I have:

Pop ups – Calendar, Calculator, Zoom box

Reply | Quote