Used a button to add to a look up field how do I auto-fill the field with the new data

[tmbartlett]

I have a form - Form1 that has a lookup field of names. If the name you are looking for isn't there I have an add name button that will open the name form in data entry mode to enter the new name. On the name form I have a close button. Once that is closed you are back at Form1. I want the name field to be automatically filled with the name you just entered without having to look it up again. Is that possible?

[Bob Fitz]

I have a form - Form1 that has a lookup field of names.

Do you mean that the form has a combo box? The I would use the "Not In List" event of the combo box to handle a new entry.

As an alternative, you may find the video at this link helpful.

[Welshgasman]

I have used the Not In List even in the past?
https://docs.microsoft.com/en-us/off...obox.notinlist

[tmbartlett]

Yes this was very helpful. I haven't used Access in about 14 years, so some of the stuff I was doing was the old way. Exactly what you described in your video. I was getting proficient at writing code back then, but I am definitely rusty and Access has changed a lot. I am also going to watch your video on "I'm not in list". Thank you very much.

[tmbartlett]

Next question: After I add the name in the name form, how do I get it to automatically fill that field in Form1. So if I am on Form1 and I want to add Mary and Mary is not in the list. I hit the edit list little icon, Name form comes up and I add Mary and when I close that I want Mary to be in the name field on Form1. I know I use to write a short code, or it was in one of the built in macros, I just can't seem to remember enough details to find it. Thank you.

[Gicu]

In the unload event of your name form check to see if Form1 is open (https://social.msdn.microsoft.com/Fo...orum=accessdev) then simply put the new name in the control:

Forms!Form1!txtFirstName=Me.txtName 'txtName is the name of the control on your Name form

Cheers,

[tmbartlett]

Gicu, Thank you. That worked perfectly.