On Not in List

[Guest]

Can anyone please help me
I have a field called 'Source' on a form called 'Prospects'. Source is a 2-column combo box tied to a two-field table called 'Sources'. Column one of the combo box is a Source Name and column two is a 2-letter abbreviation for a Source Type. I want to allow users to add a new Source (Name and Type) to the Source table and continue input into the Prospects form
So, I created an unbound form called New Sources and added unbound fields for Name and Type (Type is a listbox)
Ok, i'm pretty sure that i want to use the On Not in List property of the Source field, to open the New Sources form, but that's when i get lost. Am i doing this right
How do i save the user from typing the new source name more than once
Thanks for any help you can give.

 

[JeffW]

Look here
http://www.mvps.org/access/forms/frm0028.htm
HTH

Can anyone please help me?
I have a field called 'Source' on a form called 'Prospects'. Source is a

2-column combo box tied to a two-field table called 'Sources'. Column one
of the combo box is a Source Name and column two is a 2-letter abbreviation
for a Source Type. I want to allow users to add a new Source (Name and
Type) to the Source table and continue input into the Prospects form.

So, I created an unbound form called New Sources and added unbound fields

for Name and Type (Type is a listbox).

Ok, i'm pretty sure that i want to use the On Not in List property of the

Source field, to open the New Sources form, but that's when i get lost. Am
i doing this right?

 

[JeffW]

http://www.mvps.org/access/forms/frm0015.htm

Can anyone please help me?
I have a field called 'Source' on a form called 'Prospects'. Source is a

2-column combo box tied to a two-field table called 'Sources'. Column one
of the combo box is a Source Name and column two is a 2-letter abbreviation
for a Source Type. I want to allow users to add a new Source (Name and
Type) to the Source table and continue input into the Prospects form.

So, I created an unbound form called New Sources and added unbound fields

for Name and Type (Type is a listbox).

Ok, i'm pretty sure that i want to use the On Not in List property of the

Source field, to open the New Sources form, but that's when i get lost. Am
i doing this right?

 

[Guest]

Thanks. Do I just abandon the unbound form idea? I don't see how this code will compete the SECOND field (Source Type) in the new record. But, I'll give it a go and get back to you. :

----- JeffW wrote: ----

http://www.mvps.org/access/forms/frm0015.ht

Can anyone please help me
I have a field called 'Source' on a form called 'Prospects'. Source is

2-column combo box tied to a two-field table called 'Sources'. Column on
of the combo box is a Source Name and column two is a 2-letter abbreviatio
for a Source Type. I want to allow users to add a new Source (Name an
Type) to the Source table and continue input into the Prospects form

So, I created an unbound form called New Sources and added unbound field

for Name and Type (Type is a listbox)

Ok, i'm pretty sure that i want to use the On Not in List property of th

Source field, to open the New Sources form, but that's when i get lost. A
i doing this right