Drop Down List Being Able to Be Edited

I have a dropdown list that identifies all project names in the table A.. The dropdown list was created using the wizard that ties the dropdown list to the field called "Name" from table A. The form I created using uses table A. I am able to see the records in the drop down list, corresponds to the record count on the navigation bar. The form has the capablity to add records to table A. How do I update the dropdown list.

I start 5 records in dropdown, 5 records max in navigation bar.
Add 3 new records, 8 records max in navigation bar the 5 original names are in the dropdown list. I am expecting 8 names in the dropdown list.

You need to execute the .ReQuery method on the dropdown list. You should add code to your form to do this every time the set of records in the table changes. One way to do so is to add an event procedure for the form's AfterUpdate event. For example, if the dropdown list is a control named "lstName", the event procedure might look like:

The Form_AfterUpdate fires when I leave the form.
This does update the dropdown list when I leave.
But I want to update the dropdown list when I save the record. I tried placing the "Requery" in the Code for the Save Button.

The AfterUpdate will update the dropdown list when I leave the form.
If I started with 5 records (names) and added 3 more, when I come back into the form the dropdown list does have 8 names.
But I need to start with 5 names in the dropdown list, add a new record, I now need 6 names.
I tried placing the requey in to code for the Save button but it does not work.

This is good, however, I would add the requery on the AfterUpdate on the
text field for the Name of the Project.
This way after the name is entered into a new record and then the focus
changes to the next field the dropdown would then update.
So if the text field is named txtProjectName and combobox is named
cboProjects it would look like this:

You have to remember that we can't see what you're doing. There are so many different ways to design a form that we can't possibly explain all the factors that determine where you need to add the .ReQuery method calls.

Most of us design bound forms. That is, all (well, most) of the controls on the form are bound to fields of a data source, such as a table. With a bound form, simply navigating to another record will trigger the AfterUpdate event.

It's clear from your latest post that you are using an unbound form. You have controls where the user enters data, but they aren't connected to anything. Therefore, the user must click a command button (your Save button) in order to cause the data to be saved to the table.

Therefore, the AfterUpdate event isn't being triggered - and you need to put the .ReQuery call somewhere else - such as in the code that is executed when the user clicks on the Save button.

Good morning.
Sorry this is the first I was able to getting to the response today. You are absolutely correct Michael.
I discovered by setting breaks in the program, I discovered what and when things were occurring.
I am using an unbound dropdown list. I was able to see the steps and where the ReQuery needed to be implemented.
I would like to thank you and all members assisting me in my problems. This is now closed.