I have a many to many scenario: Table A is one set of data, Table B is
another, and Table C is my connection table for the data that is related
many-to-many.

Tables A and B are related to the appropriate fields in Table C. I am
currently using combo bozes, so when entering data in Table C, a list appears
from Table A or B. I selected No in "Limit to List."

I have created a Form for entering Data in Table C--this is all I want the
users to see.

Question: How can I set it up so that new data that does not exist in A or
B can be entered from the same field in Table C? I.e., suppose user is
entering the Customer Field in Table C (Orders). This field pulls from a
list of customers in Table A, but the Customer is new. I want the user to be
able to simply type in the new customer's name and it is now added to Table A.

You can find the solution by Checking http://www.mvps.org/access
Hint: The NotInlist Event Procedure

HTH

Pieter


<Christian > wrote in message
news:BB508F42-6632-475E-9C64-(E-Mail Removed)...
>I have a many to many scenario: Table A is one set of data, Table B is
> another, and Table C is my connection table for the data that is related
> many-to-many.
>
> Tables A and B are related to the appropriate fields in Table C. I am
> currently using combo bozes, so when entering data in Table C, a list
> appears
> from Table A or B. I selected No in "Limit to List."
>
> I have created a Form for entering Data in Table C--this is all I want the
> users to see.
>
> Question: How can I set it up so that new data that does not exist in A
> or
> B can be entered from the same field in Table C? I.e., suppose user is
> entering the Customer Field in Table C (Orders). This field pulls from a
> list of customers in Table A, but the Customer is new. I want the user to
> be
> able to simply type in the new customer's name and it is now added to
> Table A.

Okay, I found it. It's a visual Basic function...

2 Questions:

1. This seems like a pretty normal function, isn't there already a way
within access?

2. Besides adding to the drop down list, does this actually add to the
other table?

No VB code at the site *only* VBA
without the link I cant't say, but probobly yes ;-)

The notInlist event *will' fire when an entry is not in the list

HTH

Pieter

"Christian ><>" <(E-Mail Removed)> wrote in message
news:38ABCB57-148A-40E6-9F03-(E-Mail Removed)...
> Okay, I found it. It's a visual Basic function...
>
> 2 Questions:
>
> 1. This seems like a pretty normal function, isn't there already a way
> within access?
>
> 2. Besides adding to the drop down list, does this actually add to the
> other table?

"Pieter Wijnen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> The notInlist event *will' fire when an entry is not in the list

As long as the combo box's LimitToList property is set to True.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

I know,
was to lazy

ISC

Pieter

"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> "Pieter Wijnen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>
>> The notInlist event *will' fire when an entry is not in the list
>
> As long as the combo box's LimitToList property is set to True.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>